Forum Discussion
Solved
If formula
Good evening Fundamental question: I am trying to make a stock sheet, and I cannot get the IF formula to pick up the second part - the error message is "You have used too many arguments". If som...
Hanna1701.... I'm glad that helped. But I think you should explain the logic that you want in English and show us the formula that you think works for you.
It just occurred to me that perhaps the formula that you (should) want is:
=IF(D4>0, C4-D4, IF(E4>0, C4+E4, C4))
Hanna1701.... I'm glad that helped. But I think you should explain the logic that you want in English and show us the formula that you think works for you.
It just occurred to me that perhaps the formula that you (should) want is:
=IF(D4>0, C4-D4, IF(E4>0, C4+E4, C4))
- Thank you so much - got it working with your guidance.