#NUM! error for Median If Formula
I am using the following formula to get the median figure from X where AG=Central Functions, Y=Yes, and F=UK. Column X = currency. I keep getting a #NUM! error and can’t figure out why…what am I missing?
=MEDIAN(IF(AG:AG=”Central Functions*”,IF(Y:Y=”Yes”,IF(F:F=”UK”,X:X))))
I am using the following formula to get the median figure from X where AG=Central Functions, Y=Yes, and F=UK. Column X = currency. I keep getting a #NUM! error and can’t figure out why…what am I missing? =MEDIAN(IF(AG:AG=”Central Functions*”,IF(Y:Y=”Yes”,IF(F:F=”UK”,X:X)))) Read More