IF IF IF help pls

[A1058]

hello hoping somebody can help out, i feel confused right now.
here is what im trying to accomplish

IF Z2 <17 then K2 =AA2 ELSE K2 =Z2 but if Z2 = "" then K2 =""

and i need this to happen for rows 2 -31 and rows 37 - 51

i fell like this shouldnt be this hard but im drawing a blank now
any help is greatly appreciated
thank you much

 

[stanleydgromjr]

A1058,

I think I have it.

The formula goes in cell K2:

=IF(Z2<17,SUM(AA2:AA2),IF(Z2="","",SUM(Z2:Z2)))


Have a great day,
Stan

 

[Seti]

I think it may be even simpler.

In K2 put

=IF(Z2="","",IF(Z2<17,AA2,Z2))

You need to check for the null condition first, or your formula won't work.