Re: How to use more than 7 IF functions in a formula?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Greg Koppel (gregkoppel_at_hotmail.com)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 12:09:29 -0700

I have never done it, but I think the answer is to break your formula up to
use in different cells. E.g., in A1 you have the formula =If(B1=true, "yes",
"no") and in B1 you have a nested if that refers to a nested if in C1 and so
on.

HTH, Greg

"jack_sxh >" <<jack_sxh.14cw44@excelforum-nospam.com> wrote in message
news:jack_sxh.14cw44@excelforum-nospam.com...
> I tried to post a question earlier but it never appeared on the message
> list. Not sure if it went through. So here it is again.
>
> I am trying to set up a formula where when I type in a weight in
> another column it will automatically puts in an assigned value for that
> weight. The problem is that the weights range from 110 through 260. I
> have found that I cannot put in more than 7 IF functions in a formula.
> This is my first time trying to do something like this and I am having
> problems. I know there has to be a way to do this.
>
> For example I tried this formula and it worked except I con only put in
> 7 IF statements:
> If(b4=110,.988,ifb4=111,.983,if(br=112,.980 and so on to 7 IF"s
>
> Can anyone explain in detail and laymens terms how I can solve this
> problem. I am definitely a newbie and need help.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: Strip out text from cells
    ... "Rick Rothstein" wrote: ... list of what you want to have after you process those entries. ... concerned is the lbs in weight (ie one column shows the weight in stones - ... my apologies if I was not as clear first time ...
    (microsoft.public.excel)
  • Re: A David Letterman Thread with POSITIVE Energy
    ... The first time ever I saw his face was the first night he appeared on ... the Johnny Carson TONIGHT show, and I thought it was the best first ... Dave used to answer Viewer Mail. ... The above list was from me, not Greg. ...
    (alt.fan.letterman)
  • Re: OT: Ramashiva at 288 pounds
    ... I went to see my doctor today for the first time in two years, ... The last time I checked in with this doctor two years ago, ... > I can relate to the weight issue. ... > healthy diet, I gain weight very easily and have to force myself to ...
    (rec.gambling.poker)
  • Re: OT Long-Awaited Medical Study Questions the Power of Prayer
    ... Have you ever considered prayer as part of your "weight reduction ... And I am slimmer, regardless of the weight. ... But not the first time you use it. ... "That's not why I pray, ...
    (rec.outdoors.rv-travel)
  • Re: module-init-tools - input devices id support
    ... This is the first time I've looked at the input code, ... at least so I was assured by Greg. ... But it's designed for the hotplug stuff. ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)