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

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)