Multiple if issue

[rfletcher35]

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

 

[CROY1985]

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]

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

 

[WaterGypsy]

Are you sure there is nothing ? Could there be a space?

 

[husoi]

ADVERTISEMENT

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

 

[keiserj]

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

 

[husoi]

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]

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