triple if?

[Evelyte]

I need to put all these requirements into one cell:

if H20>250, then average(xxx)
if H20<250, then average(xxx)+25
if H20 is blank, then leave blank

I've started to put something:
=IF(H20>250;AVERAGE(xxx));IF(H20<250;AVERAGE(xxx)+25);““)
but it's still not what I need

[Jonmo1]

Try

=IF(H20="";"";IF(H20>250;AVERAGE(xxx);AVERAGE(xxx)+25))
Or
=IF(H20="";"";AVERAGE(xxx)+((H20<250)*25))

[FinlayH]

Try:

Please Login or Register  to view this content.