IF command to have cell display no value & return equal to or greater that a value.

[davidmstorey]

Hi Guys

I need help. Attached is my document. Column O is a total of all my days both in and out of the UK, see column P for a short explanation. I need to have the #NUM and #VALUE default to a blank cell when it can't find a value in column C & F. I also need to configure the cell at the bottom of column O to display the message "QUALIFY" in green if a number in any of the cells in column O are equal to or greater that 365.......

Much appreciated...

[protonLeah]

=iferror(i5+o5,"")

=IF(MAX(O4:O20)>365,"QUALIFY","FAIL")

[ConneXionLost]

In columns I and O, use formulas in the style of:

Please Login or Register  to view this content.

and in column O, use SUM:

Please Login or Register  to view this content.

instead of =L5+O4

Finally, in N22, use"

Please Login or Register  to view this content.

Cheers,

[davidmstorey]

Hi guys, thank you for your help.. You rock.