Formula

[kib]

How to i create this formula in excel

"IF the amount should in cell A1 is more than 250, then
take the larger figure of either A2 or A3 and add the
amount shown in A1"

Thanks!

 

[Alan Beban]

=IF(A1>250,A1+MAX(A2,A3),"not more than 250")

Alan Beban

 

[Gord Dibben]

Oops!

=IF(A1>250,MAX((B1:B2)+A1),("A1 not greater than 250"))

Change B1:B2 to A2:A3

Gord