Solved excel - greater than less than

October 31, 2016 at 05:50:07
Specs: Windows 7
I am having problems creating the following rule

If X is greater than 66 but less than 39, then multiply X by 10%, otherwise cell to equal 0


See More: excel - greater than less than

Report •

#1
October 31, 2016 at 08:14:05
✔ Best Answer
You'll need the AND() OR() function so something like:

IF( AND(A1>66,A1<39) , A1*10% , 0 )

IF( OR(A1>66,A1<39) , A1*10% , 0 )

And, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
October 31, 2016 at 09:42:25
Do you mean greater than 39, but less than 66?

Report •
Related Solutions


Ask Question