I think I need a multiple IF statement, or is there another wa
in [Functions]
|
Prev: I think I need a multiple IF statement, or is there another way?
Next: Formula Result is different from the shown result
From: Jacob Skaria on 18 Mar 2010 06:53 =A1-(A1*IF(A1<=50,10%,IF(A1<=100,20%,IF(A1<=500,30%)))) -- Jacob "Carl Waring" wrote: > Actually, scratch that. I mis-interpreted what I needed to do but I can't > edit or delete the post :-( That said, it still might be useful to know ;-) > > This is what I need to know! > > If the number in [cell] is <=X then take off A% > then > If the number in [cell] is <=X then take off B% > then > If the number in [cell] is <=X then take off C% > then > Display result > > > Thanks.
From: Jacob Skaria on 18 Mar 2010 06:57
One way using IF() =A1-(A1*IF(A1<=50,10%,IF(A1<=100,20%,IF(A1<=500,30%)))) -- Jacob "Carl Waring" wrote: > Actually, scratch that. I mis-interpreted what I needed to do but I can't > edit or delete the post :-( That said, it still might be useful to know ;-) > > This is what I need to know! > > If the number in [cell] is <=X then take off A% > then > If the number in [cell] is <=X then take off B% > then > If the number in [cell] is <=X then take off C% > then > Display result > > > Thanks. |