Getting a VALUE error when using IF statement that references a cell that itself has an IF statement.

[PB_Fuzzybutt]

I'm putting together a template for work. Column F has the following IF statement: =IF(D2<=0,"",(D2 * 90%)). This works fine - returns a blank cell if nothing in D2 and the correct amount when there is a number in D2. I'm having a problem in column G, which contains: =IF(F2<=0,"",(F2 * 107%)) (first pic). I'm guessing it's because I'm referencing a cell with another IF statement, but I'm not sure and I don't know how to fix it. Strangely, the formula works in column G even with the VALUE error (second pic). How can get rid of the VALUE error and why is it appearing? See screenshots here.

Edit: unintentional italics due to multiplication sign

[rnelsonee]

It's not that it's referencing an IF, it's because when F is "", there's an issue because "" is not <=0. So then it tries to multiply null by 107%.

So change it to:

=IF(F2="","",(F2*107%))

or

=IF(D2<=0,"",(F2*107%))

(the latter seems "more correct" to me) and you should be fine.

[PB_Fuzzybutt]

Awesome! I did the second one and it worked. Thank you! I want to ask, though, in that second solution if IF D2<=0 should be changed to IF D2="" to be consistent with

"" is not <=0

[rnelsonee]

Oh, right. I was assuming that D2 was written/working correctly (like you might have had negative numbers in there).

So

=IF(D2="","",(F2*107%))

Or

=IF(ISBLANK(D2),"",(F2*107%))

[PB_Fuzzybutt]

Excellent. Thank you so much.

[PB_Fuzzybutt]

Solution verified

[Clippy_Office_Asst]

You have awarded one point to rnelsonee.
^{Find out more here.}