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