Microsoft Office Forums - View Single Post - IF formula returns TRUE instead of evaluating COUNTIF

Thread: IF formula returns TRUE instead of evaluating COUNTIF

View Single Post

Old

12-28-2011, 05:02 AM

Catalin.B

Catalin.B is offline

Catalin.B uses Windows Vista

Windows Vista Catalin.B uses Office 2010 32bit

Catalin.B uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Catalin.B is on a distinguished road

Default

in the IF function, for Value if true, you should have
COUNTIF(A22:Y22,">"& E22) not
"=COUNTIF(A22:Y22,">"& E22)"

Reply With Quote