Hi everyone,
I am basically trying to tell excel to use a specific formula if two conditions are met and what do to do if they aren't:
This is basically what I want to do:
If ***=male and BMI<=28, then use x(m) formula; if ***=male and BMI>28;then use xy(m) formula
If ***=female and BMI<=28, then use x(f) formula; if ***=female and BMI>28;then use xy(f) formula
Been struggling with this for a while now, so I would appreciate any help
whats the ***
possibly the forum seeing a word
a Nested IF
=IF ( AND ( ***=male , BMI<=28) , x(m) , if ( AND (***=male , BMI>28) , xy(m), If ( AND ( ***=female , BMI<=28), x(f) , if (AND( ***=female , BMI>28), xy(f) , "criteria not meet") )))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hey man thanks for the input, I have been using that nested if statement for a while now but I keep getting the #NAME? error, can't figure out what's wrong with it :s
the *** is the forum moderating the word made up from the caps in these words...Shoiuld Expect eXtra
Seeing as you have so many letters there that could be range names, maybe upload a sample workbook for us to look at?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks