Re: nesting for 2 dependents, and 4 formula options

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

Thanks very much Tom.
It is hard to see these things when you aren't looking at them regularly,
are mentally tired and are unsure of the syntax in the first place.

The formulae will be put to a great use, and many will benefit freely, so
please know your time has been well spent.

Cheers
Bruce Gray
Grays Health






=IF(AND(B3="male",B4>60),(0.049*B6+2.459)/0.004184,
IF(AND(B3="male",B4>30),(0.048*B6+3.653)/0.004184,
IF(AND(B3="female",B4>60),(0.038*B6+2.755)/0.004184,
IF(AND(B3="female",B4>30),(0.034*B6+3.538)/0.004184,"out of range"))))


You had several unpaired parentheses. I removed the paren after B6 since
it
isn't needed - multiplication occurs before addition.
You alos were missing one in the third IF

=IF(AND(B3="male",B4>60),(0.049*B6+2.459)/0.004184,
IF(AND(B3="male",B4>30),(0.048*B6+3.653)/0.004184,
IF(AND(B3="female",B4>60),(0.038*B6+2.755)/0.004184,
IF(AND(B3="female",B4>30),(0.048*B6+3.653)/0.004184,"out of range"))))

--
Regards,
Tom Ogilvy


"dodo news" <bruce@xxxxxxxxxxx> wrote in message
news:4407a2aa$1@xxxxxxxxxxxxxxxxxxxxxxxx
Thanks for prompt reply Bob and Tom,

i've messed with your syntax and am still having error reports
have broken up the formula into lines to make it easier to read.
Would greatly appreciate your perusal.
TIA

=IF(AND(B3="male",B4>60),(0.049*B6)+2.459)/0.004184,
IF(AND(B3="male",B4>30),(0.048*B6)+3.653)/0.004184,
IF(AND(B3="female",B4>60),(0.038*B6)+2.755/0.004184,
IF(AND(B3="female",B4>30),(0.048*B6)+3.653)/0.004184,"out of range")








=If (And(a1="male",a2>30), (0.048*a3)+3.653, if(And(
a1="male",a2>60),(0.049*a3)+2.459,"burp"))

should work for 5 more, 7 is the limit



=IF(AND(A1=1,B1=1),1,IF(AND(A1=2,B1=2),2,IF(AND(A1=3,B1=3),3,IF(AND(A1=4,B1=

4),4,IF(AND(A1=5,B1=5),5,IF(AND(A1=6,B1=6),6,IF(AND(A1=7,B1=7),7,8)))))))

--
Regards,
Tom Ogilvy



"dodo news" <bruce@xxxxxxxxxxx> wrote in message
news:44075822$1@xxxxxxxxxxxxxxxxxxxxxxxx
I want to choose one of four formulas to use, conditional on the
contents
of
two cells

i.e.
If a1="male" and a2>30, (0.048*a3)+3.653, if a1="male' and a2>60,
(0.049*a3)+2.459, if for two more formulas

I was trying to do a combined =IF(AND, but this doesn't seem to be
nestable....

Any help appreciated....
TIA










.

Relevant Pages

  • Re: nesting for 2 dependents, and 4 formula options
    ... (remove nothere from email address if mailing direct) ... are mentally tired and are unsure of the syntax in the first place. ... Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: activeworkbook.saveas - saving format changes
    ... You had the syntax. ... >>Tom Ogilvy ... >>> excel I have lost all the formatting changes. ... >>> Sub createMpetReport() ...
    (microsoft.public.excel.programming)
  • Re: What should I do when this has no data?
    ... "Tom Ogilvy" wrote in message ... > Sub SortByDate() ... This syntax, as originally given, works perfectly when there is data in the ... sort. ...
    (microsoft.public.excel.programming)
  • Re: What should I do when this has no data?
    ... "Tom Ogilvy" wrote in message ... I end up in cell B65536 with the exact error ... >> I wish there was an easier way for us to determine syntax, ... >> Sub SortByDate() ...
    (microsoft.public.excel.programming)
  • Re: Still need help with Access DB Query!!
    ... Access queries seem to be extremely finicky with the syntax. ... "Tom Ogilvy" wrote: ... If I use the three quotes, ...
    (microsoft.public.excel.programming)