Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   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%))



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"