I think I need a multiple IF statement, or is there another way?
in [Functions]
|
Prev: column corresponding to row number
Next: I think I need a multiple IF statement, or is there another wa
From: Carl Waring on 18 Mar 2010 05:51 I can do the simple stuff, but this is more complicated! In English, this is what I want to do If the number in [cell] is <=X then take off % then If the number in [cell] is <=Y then take off a further % then If the number in [cell] is <=Z then take off a further % then Display result It's probably as nested IF statement, but I don't know how to construct it. Thanks.
From: Carl Waring on 18 Mar 2010 06:00 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: Bob Phillips on 18 Mar 2010 06:15 Try =IF(A2<=x,A2*90%,IF(A2<=Y,A2*80%,IF(A2<=Z,A2*75%,A2))) -- HTH Bob "Carl Waring" <CarlWaring(a)discussions.microsoft.com> wrote in message news:A5195AB6-19E2-4000-ABE1-55B4B7E8C3DA(a)microsoft.com... >I can do the simple stuff, but this is more complicated! > > In English, this is what I want to do > > If the number in [cell] is <=X then take off % > then > If the number in [cell] is <=Y then take off a further % > then > If the number in [cell] is <=Z then take off a further % > then > Display result > > It's probably as nested IF statement, but I don't know how to construct > it. > > Thanks.
From: Ron Rosenfeld on 18 Mar 2010 06:25
On Thu, 18 Mar 2010 03:00:01 -0700, Carl Waring <CarlWaring(a)discussions.microsoft.com> 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. I'm not sure you've stated it correctly, but something like: =if(cell<=x,(1-a-b-c)*x,x) --ron |