Show IF

J

John-mlrsman01

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
 
P

Pete_UK

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
 
J

John-mlrsman01

Pete
Thanks for the help


Pete_UK said:
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
Click to expand...
 
Top