If and logic

[Closed]
Report
Posts
1
Registration date
Wednesday January 2, 2013
Status
Member
Last seen
January 2, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am trying to write an Excel formula where i have a condition statement that varies result. For example if my target figure is > 30 but less than 50, i want to return a response of 0.1, but if the target is < 30, i want to return a response of 0.05 and if target is greater than 50, i want to return a response of 0.075.

Any help with this is greatly appreciated.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
=IF(A1="", "", IF(A1<30,0.05,IF(A1<50,0.1,0.075)))