Forum Discussion

Copper Contributor

Jul 05, 2019

Not sure what type of excel formula to use

I have one cell (lets say it is cell Z20) in which I need several things evaluated and different things done based upon the answer. This is based upon dollar amounts in columns N and L. Both column...

excel

Formulas and Functions

Twifoo

Silver Contributor

Jul 05, 2019

jhassi

Your formula seems that it can be reduced to this:

=IF(L20,

Z15-L20,

N20*15%)

jhassi
Copper Contributor
Jul 05, 2019
This doesn't address the logical test for N20
- Twifoo
  Silver Contributor
  Jul 05, 2019
  My suggested formula is premised on your declaration of a fact that whenever L20 is 0, N20 is not 0, and whenever N20 is 0, L20 is not 0. If my suggested formula returns a result you didn’t expect, it presupposes that you may have to modify your premise. The logic of any formula always depends upon the premise you declare.