Forum Discussion
Lengthy If And Formula
Hi All, I'm looking for a way to simplify the IF And formula below. I believe there should be an easier way to do this without writing numerous IF And statements in one line. You will note the formu...
I will try switch first.
=Switch(True(),B3<2000,0,B3<2499,35,B3<2999,60.....B3<11999,510,535)
Also you could list a support table.
Input the size in column C
and maybe in column D use fomular as below
=LOOKUP(C2,$A$2:$A$23,$B$2:$B$23)
Next time you just need to check the value in A or B