IF Statement for Multiple conditions with ± results

I run photo competions for my camera club {not for profit}. Judges' scores must be within a 9 point spread or they must rescore. I need this condition flagged for attention. So, the formula will look...

Excel Desktop

Formulas & Functions

William Curran
Mar 31, 2018
Detlef_Lewin wrote:

Select cell J3 and press key F2.

Do you notice something?

=IF(MAX(F3:H3)-MIN(F3:H3)>10,"X","") - Oh! should be

=IF(MAX(F5:H5)-MIN(F5:H5)>10,"X","") in J3 - All the cells are off as I started with F1:H1...

when it should have been F3:H3... I read image numbers, column A insteads of row numbers in setting up the inital formula! It onlymarks conditions for 11 and above, though as it is so I hadto change the 10 to a 9. Now, all is work well. Thank you!

Detlef_Lewin

Silver Contributor

Mar 30, 2018

Select cell J3 and press key F2.

Do you notice something?

William Curran

Copper Contributor

Mar 31, 2018

Detlef_Lewin wrote:

Select cell J3 and press key F2.

Do you notice something?

=IF(MAX(F3:H3)-MIN(F3:H3)>10,"X","") - Oh! should be

=IF(MAX(F5:H5)-MIN(F5:H5)>10,"X","") in J3 - All the cells are off as I started with F1:H1...

when it should have been F3:H3... I read image numbers, column A insteads of row numbers in setting up the inital formula! It onlymarks conditions for 11 and above, though as it is so I hadto change the 10 to a 9. Now, all is work well. Thank you!

Forum Discussion

IF Statement for Multiple conditions with ± results

Resources