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

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

message edited by mmcconaghy

Do you mean greater than 39, but less than 66?

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History