I have a spreadshet that shows my cost for a particular product in one cell,
my competitors price in another and then in the following columns I have a
cost plus formula (cost +10%, cost+20%, and so on) I only want to show a cell
if a specific cell is less than my competitors.

I am trying look for trends that I can adjust for and figure the visual
representation will help.

Can anyone help me with this?

Thanks
John

Try this:

=IF(cost*1.1=competitor_price,"",cost*1.1)

you will need to substitute appropriate cell references for cost and
competitor_price, and then copy down for 10%. Change it to 1.2 for 20%
etc.

Hope this helps.

Pete

On Apr 22, 3:37*pm, John-mlrsman01 <John-
wrote:
I have a spreadshet that shows my cost for a particular product in one cell,
my competitors price in another and then in the following columns I have a
cost plus formula (cost +10%, cost+20%, and so on) I only want to show a cell
if a specific cell is less than my competitors.

I am trying look for trends that I can adjust for and figure the visual
representation will help.

Can anyone help me with this?

Thanks
John

Pete
Thanks for the help


"Pete_UK" wrote:

Try this:

=IF(cost*1.1=competitor_price,"",cost*1.1)

you will need to substitute appropriate cell references for cost and
competitor_price, and then copy down for 10%. Change it to 1.2 for 20%
etc.

Hope this helps.

Pete

On Apr 22, 3:37 pm, John-mlrsman01 <John-
wrote:
I have a spreadshet that shows my cost for a particular product in one cell,
my competitors price in another and then in the following columns I have a
cost plus formula (cost +10%, cost+20%, and so on) I only want to show a cell
if a specific cell is less than my competitors.

I am trying look for trends that I can adjust for and figure the visual
representation will help.

Can anyone help me with this?

Thanks
John

You're welcome - thanks for feeding back.

Pete

On Apr 22, 4:23*pm, John-mlrsman01
wrote:
Pete
Thanks for the help