I am trying to create a way to compare prices in one column against prices in a second column. But the prices in the second column are divided by a percentage to try and equal the first column. For example if the price in column 2 is between $5-$10 then the value is divided by .95. That value is then compared to the value in column 1. Is there a way to do this?

I'm sorry, but I don't understand what it is your after.

For example if the price in column 2 is between $5-$10 then the value is divided by .95.This formula will do that:

=IF(AND(B1>=5,B1<=10),B2/0.95,0)

But it would have to be placed in Cell C1

You could then compare A1 to C1.

MIKE

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History