IF statement formula structure help

[cubs610]

Hello All,

To make things easier attached is a spreadsheets with comment to help spell things out. In short here is what I'm looking to solve.

We work with a product list that lists many columns, of which the key one are: wholesale, retail, our price and displayed. The our price and displayed are calculated columns. I'm looking to create an IF statement (I guess) that will calculate the following:

If our retail is <20% of standard retail then display the product. If our retail is >20% then do not display the product.

As a bonus formula of the ones that are not displayed we'd like to recalculate at 35%, or cell/ .65.

Please see attached. Love to hear your thoughts and many thanks!
-Dave

 

[GraH - Guido]

Not sure I have interpreted the calculation you want correctly, but would this work:
in G2 : =D2<(E2*1,2) and drag down
In I2: = =IF(G2;;C2/0,65) and drag down

 

[cubs610]

Not sure I have interpreted the calculation you want correctly, but would this work:
in G2 : =D2<(E2*1,2) and drag down
In I2: = =IF(G2;;C2/0,65) and drag down

Hey GraH,

Yeah... I gotta admit it was the end result of a hurried conversation of which I wrote down what the powers that be are looking for. I'll take a peek at your suggestion.

Many thanks!
-Dave