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 Jony Ive could make a big impact on Airbnb?

Discuss in The Lounge

Poll History