Link 2 different variables to Male/Female for no' alcohol units

**Woody3ER** · 09-13-2013, 11:15 AM

Hi there

I am trying to work out how I can have an integer score for number of units of alcohol consumed in 1 week with an outcome that is different depending on if you are male or female.

I have attached a worksheet with some example data - I would like to be able to type in the number of units someone says they consume on average within one week and the box next to it gives a verbal description of whether this is an acceptable amount or not according to the UK guidelines. This is 21 units per week for men and 14 for women. Not sure how to create this formula and link in the gender differences

Thanksalcohol.xls

**L-Drr** · 09-13-2013, 01:13 PM

I´m not sure if you also record if a person is male or female, or if you just want to give both answers.
In the first case, assuming the number of consumptions is in A1 and the gender is in B1, use this in C1:
=IF(OR(AND(A1<=21,B1="Male"),AND(A1<=14,B1="Female")),"Acceptable","Not acceptable")

In the second case, you could build something like this (same assumption for A1):
=IF(A1<=14,"Acceptable for both males and females",IF(A1<=21,"Acceptable for males, unacceptable for females","Unacceptable for both males and females"))

**Woody3ER** · 09-16-2013, 03:50 AM

Works perfectly, thank you

Link 2 different variables to Male/Female for no' alcohol units

LinkBack

Thread Tools

Rate This Thread

Display

Link 2 different variables to Male/Female for no' alcohol units

Re: Link 2 different variables to Male/Female for no' alcohol units

Re: Link 2 different variables to Male/Female for no' alcohol units

Thread Information

Users Browsing this Thread

Similar Threads

Automatically adding Mr or Ms to male/female

[SOLVED] Formula for male and female staff on rota

Having a problem with the =IF male/female formating and vlookup...

Excel Male / Female Column

IF male or female IF age is in range...THEN...

Bookmarks

Bookmarks

Posting Permissions