Logo 
Search:

MS Office Forum

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

A wee question

  Asked By: Zobah    Date: Aug 18    Category: MS Office    Views: 393
  

=IF(B20<20000,2.5%,3.5%)
In this one if it is greater than 20000 they get 3.5% but if it is 20000 or
less they get 2.5
So I think I am missing a dollar. ( No pun intended) how should I write it
for less or equal to equal? Oh maybe I stick in an = sign.
Any thoughts?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Fahmida Ahmed     Answered On: Aug 18

<= should do it.................................

 
Answer #2    Answered By: Vidhya Iyer     Answered On: Aug 18

Reverse the logical, use =IF(B20>20000,3.5%,2.5%)

 
Didn't find what you were looking for? Find more on A wee question Or get search suggestion and latest updates.




Tagged: