Greetings All,
I've got a task for an assignment thats driving me crazy...
I've got a worksheet called Data & one called Male (in the same wookbook). The data sheets lists gender (as M or F) & values related to height and weight.
My task is : "Use an IF function to copy appropriate male data from the data worksheet to the male worksheet"
I've worked out how to get a M result or leave a blank if its female in the Gender column on sheet Male but cannot figure out how to transfer the data for the other characteristics.
My starting point is :
=IF(Data!$B2="M","M","")
Now what do I do? Do I need nested IF statements or can the value_if_true be made to include all value on that row from Data sheet?
Second question - the row range is 2:207 - do I just fill the formula down or can it all be done with one IF statement using 2:207 arguement (somehow)?
Thanks in advance for any help.
I've got a task for an assignment thats driving me crazy...
I've got a worksheet called Data & one called Male (in the same wookbook). The data sheets lists gender (as M or F) & values related to height and weight.
My task is : "Use an IF function to copy appropriate male data from the data worksheet to the male worksheet"
I've worked out how to get a M result or leave a blank if its female in the Gender column on sheet Male but cannot figure out how to transfer the data for the other characteristics.
My starting point is :
=IF(Data!$B2="M","M","")
Now what do I do? Do I need nested IF statements or can the value_if_true be made to include all value on that row from Data sheet?
Second question - the row range is 2:207 - do I just fill the formula down or can it all be done with one IF statement using 2:207 arguement (somehow)?
Thanks in advance for any help.