Can we put a formula in the "value_if_true" field in an IF Function in Excel?

Question

I have a situation where i need to put a formula in the "Value_if_true" and "Value_if_false" fields in an IF function but it does not seems to be working. It just keeps displaying my formula as is in the cell. Can someone help?

Answer 1

You can put a formula in another cell and point the if statement to that cell for the result.

For example

A1    =IF(B1,C1,D1)
B1    = 1
C1    =1+5

A1 will equal 6

Also, you can enter simple nested formulas like so:

A1      =IF(B1, IF(B2, B3, B4), B5)

As you've now provided the formula, i'll fix it:

=IF(I5=0,(12-BC5)*BE5 + BH5,BF5)

should work

Answer 2

Um... Just remove all inner quotes from your formula.

Answer 3

This has wrong " characters

=IF(I5=0,"(12-BC5)*BE5 + BH5","BF5")

"(12-BC5)*BE5 + BH5" is a string. Not a formula. Use this.

=IF(I5=0,(12-BC5)*BE5 + BH5,BF5)