# IF IF IF help pls

#### A1058

##### New Member
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

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
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

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.

Replies
11
Views
5K
Replies
7
Views
188
Replies
5
Views
447
Replies
1
Views
464
Replies
0
Views
553

1,217,500
Messages
6,137,008
Members
450,038
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back