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: 882

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?



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.