Solved vba code or conditional formatting

August 21, 2013 at 08:50:43
Specs: Windows 7
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?

See More: vba code or conditional formatting

Report •

#1
August 21, 2013 at 13:49:51
✔ Best Answer
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

http://www.skeptic.com/


Report •
Related Solutions


Ask Question