Thread: 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!

Assuming A1:B5 is your range, try this

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

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
>
>