If Functions

[Titch]

When using an IF function how can i write:

If C4 is larger than the value in cells
C5,C6,C7,C8,C9,C10,C11,C12,C13 write yes but if it isnt
write no

 

[Bob Phillips]

Very simply


=IF(AND(C4>C5,C4>C6,C4>C7,C4>C8,C4>C9,C4>C10,C4>C11,C4>C12,C4>C13),"Yes","No
")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Barbara]

When using an IF function how can i write:

If C4 is larger than the value in cells
C5,C6,C7,C8,C9,C10,C11,C12,C13 write yes but if it isnt
write no

=IF(C4>MAX(C5:C13),"Yes","No")

Regards
Barbara