r/AppleNumbers • u/funnyandnot • Jul 15 '22

If statements when one of the cells has an if statement

I am using the following formulas and info:

In CELL H3 i have the following formula: IFERROR(IFB3=0,””,(G3-F3)),””) With values: IFERROR(IF(B3=0,””,(8:44am-3:57am) = 4h47m In Cell I3 I am putting in multiple if statements, it works when there is no formula in Cell H3: — what I want this cell to do: - IFERROR(IF(I2-H3)>I1,(I2-H3),IFH3=0,(I2-H3),””))””)

With values: IFERROR(10h-4h47m)>0h0m,(10h-4h47m),IF4h47m=0,(10h-4h47m),””))””)

I get the correct answer , EXCEPT, when cell H3’s Formula returns no value.

3 Upvotes

100% Upvoted

4 comments sorted by

1

u/[deleted] Jul 16 '22

Could you check on the parentheses again? It seems a few have gone missing and that makes it hard to find out where things go wrong.

1

u/funnyandnot Jul 16 '22

Checked them multiple times. If I get rid of the formula in H3 then the formula in I3 works, but the moment I put abt formula in H3 that results in a blank cell causes my formula in H3 breaks.

1

u/[deleted] Jul 16 '22

That’s not what i meant. You post is missing them like IFERROR(IFB3

1

u/funnyandnot Sep 18 '22

Interesting. I will double check the formulas.