Thread: I think I need a multiple IF statement, or is there another way?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default I think I need a multiple IF statement, or is there another wa
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.
Reply With QuoteReply With Quote