If, and Statement help

Imran Azam

Board Regular
Joined
Mar 15, 2011
Messages
78
Hi Guys,

I am trying to write an if statement based on the results in cell A1 and i cant seem to get this correct

the rules i want to apply in the statement are

If A1 > 0.49 then A1=100
If A1 > 0.39 and less then 0.50 then A1=75
If A1 >0.29 and less then 0.40 then A1= 50

how can i write this in one If statement

thank you guys
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
766
Office Version
  1. 365
Platform
  1. Windows
Try:
IF(A1>0.49,100,IF(A1>0.39,75,IF(A1>0.29,50,0)))

In cell B1
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,328
Members
409,863
Latest member
stacy09
Top