# Multiple if issue

#### rfletcher35

##### Active Member
I have the following formula in Cell T967

=IFs(P967="","None",IF(AC967="","",\$U\$2-P967))

What i'm trying to achieve is the following

If AC967=Nothing then in Cell T967 leave blank
If P967 = Nothing then in Cell T967 put None
if non of the above to criteria is true the perform the calculation U2-P967 and place that value in Cell T967

Any ideas guys i'm sure this is simple but not getting my head around it right now!

Thanks

Fletch

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### CROY1985

##### Active Member
I think youve just got the order of operations wrong way round in the formula, try this:

 =IF(AC967="","",IF(P967="","None",U2-P967))

<tbody>
</tbody>

#### rfletcher35

##### Active Member
I've tried your formula but it is still putting "none" even though there is nothing in AC967?

#### WaterGypsy

##### Well-known Member
Are you sure there is nothing ? Could there be a space?

#### husoi

##### Board Regular
Have you tried using AND () inside the IF formula?
The way you're doing is getting conflict with the FALSE statements.

#### keiserj

##### Board Regular
=IF(AND(P967="",AC967=""),"",U2-p967)

#### husoi

##### Board Regular
Have you tried using AND () inside the IF formula?
The way you're doing is getting conflict with the FALSE statements.

You have to think what you want to happen in both TRUE and FALSE statements for all 3 conditions.
The way you have built your formula is only considering part of the statement that's why is not giving the correct result.

=IF(AND(A2="",A3=""),D2-F2,IF(AND(A2<>"",A3=""),"None","")) then you have to add the argument for the reverse (A2="" and A3<>"")

change the cells to serve your sheet.

Hu

#### rfletcher35

##### Active Member
Apologies guys there was a formula in there and even though the cell was blank reporting no info it wasn't registering as blank. Solved it now thanks for all your help

Fletch

Replies
0
Views
435
Replies
1
Views
2K
Replies
3
Views
450
Replies
0
Views
585
Replies
3
Views
2K

1,195,659
Messages
6,010,956
Members
441,578
Latest member
brodiej

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