IF and AND statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to write a formula to calculate a percentage...
My data is as follows:

Standard Cost = 10
Selling Price = 14
SP1 = 14
SP2 = 13
SP3 = 12

I need the formula to express...
If SP3 has a value, calculate % diff between SP3 and Standard cost. If SP3 =
0, calculate using SP2, if SP2 = 0, calculate using SP1, if SP1 = 0,
calculate using default selling price.

Help!
 
Assuming A1:B5 is your range, try this

=IF(B5 = "", IF(B4 = "", ABS(1-(B3/B1)), ABS(1-(B4/B1))),
ABS(1-(B5/B1)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing two sheet of data -- cost price increases 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Excel formula, sum the value cell and if empty cell left blank 0
More than 7 nested IF(AND... 1
What's the best way to set this formula up? 0
TWO IF 1
how do i get excel to use data in a table based on the result of a 2
Formula assistance - if / then statement 1

Back
Top