If and logic

Closed
antress Posts 1 Registration date Wednesday January 2, 2013 Status Member Last seen January 2, 2013 - Jan 2, 2013 at 10:47 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 4, 2013 at 04:08 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 4, 2013 at 04:08 PM
=IF(A1="", "", IF(A1<30,0.05,IF(A1<50,0.1,0.075)))
0