Thread: IF THEn Formula
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.newusers
Mc/ Mc/ is offline
external usenet poster
 
Posts: 5
Default IF THEn Formula

if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04
You almost have the formula correct as you presented the issue.

You must keep in mind that the IF/THEN/ELSE function will stop considering
conditions, when the first TRUE path has been determined.

I also use the = and <= conditional operative.

=if(A1=20,000,A1*0.04,(A1<=10000,A1*0.08, A1*0.06))
-OR-
=if(A1<=10,000,A1*0.08,(A1=20000,A1*0.04, A1*0.06))
However, I like the format of showing the percentage rather than the decimal
equivalent as follows;

=if(A1<=10,000,A1*8%,(A1=20000,A1*4%, A1*6%))