Show IF

  • Thread starter Thread starter John-mlrsman01
  • Start date Start date
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
 
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
 
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...
 
Back
Top