Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Case Logic Wireless Mouse EW-600
The Sarge -
Dpick -

11 responses
Case Logic EW 600 wireless Mouse
Rob58 -
Iamanidiot -

4 responses
Case logic wireless rechargable gaming mouse cl-ms-ws-111 light not staying on o
Carlton -
Facebookcoder -

6 responses
model EW-1010 case Logic Wireless mouse
Marilyn Rackley -
xpcman -

2 responses
What is the difference between the number of cores and the number of logical pro
jamalnuman -
jamalnuman -

7 responses