If and logic

Closed
antress Posts 1 Registration date Wednesday 2 January 2013 Status Member Last seen 2 January 2013 - 2 Jan 2013 à 22:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 4 Jan 2013 à 16:08
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
4 Jan 2013 à 16:08
=IF(A1="", "", IF(A1<30,0.05,IF(A1<50,0.1,0.075)))