Conditional function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to make a conditional formula based ont he below info

If A=75 then the column B must show 5%
If A >90 & <=99 then column B must show 7%
If A = 100 then Column B must show 8%

Please help me make this formula
 
There are some other conditions not covered by your requirements, i.e.
if A < 75, or A >75 and <=90, or A >100. What do you want to happen in
these cases?

Pete
 
=if(A1=100,.08,if(A1>90,0.07,if(A1=75,0.05,"")))
assuming you want it blank when none of the conditins are met.
 
=IF(A1=75,5%,IF(AND(A1>90,A1<=99),7%,IF(A1=100,8%,"undefined")))
 
=IF(A1=75,0.05,IF(A1<=90,0.06,IF(A1<=99,0.07,IF(A1=100,0.08,"else…."))))
 
you are right I assumed that 100 was the max the value would be, with no
justification for the assumption.
=if(A1=100,.08,if(and(A1>90,A1<=99),0.07,if(A1=75,0.05,"")))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Scrabble Value calculation for Welsh words 0
Conditional Formatting 3
Average with Conditions 1
IF Multiple Conditions 2
Returning 1 of 4 values if conditions are met 4
Formula for giving point to particular no. 2
Adding up total hours worked on employee schedule using various criteria 0

Back
Top