IF and AND statements
 

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!

IF and AND statements
 

Assuming A1:B5 is your range, try this

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


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548624

IF and AND statements
 

I've done this a different way, sorry I forgot to rate your reply until now

"Bearacade" wrote:


Assuming A1:B5 is your range, try this

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


--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=548624