Forum Discussion
MickeyMouse
Jan 21, 2021Copper Contributor
Excel formulae with three different conditons
Can someone assist in getting this formulae in one cell?
MickeyMouse
Jan 22, 2021Copper Contributor
I got the solution using IF. See below the attachment of the formulae.
Lete also try the Xlookup.
Lete also try the Xlookup.
mathetes
Jan 22, 2021Silver Contributor
It's definitely possible to do that with IF. But you don't really want to; it's not a good long term solution for a variety of reasons. First, you're only dealing with two levels of the tax tables, so it's limited that way; second, the longer the nested set of IF conditions gets, the harder it is to follow them; IFS is an option, but it too is prey to the next reason not to approach it this way: third, it's really not good practice to hard code numbers into formulas when those numbers can change, as tax related numbers WILL do;