Hello everyone, thank you for all your help and assistance on this platform. I am in current need of your help once more. I have been trying to use the 'If' and 'And' function in Excel to create a formula that will show "He or She" based on the following criteria.
(a) Cell E13 as Gender
(b) Cell AH42 as pupil's percentage.
I want a situation where if E13 is equal to "MALE or FEMALE" and the pupil's percentage is less than 80%, Cell A42 shows "He or she" depending on the gender selected in E13.
Then the second condition is that A42 will show nothing if AH42 is greater than 80%.
Below is the formula I used but it isn't working.
=IF(AND(E13= "MALE", AH42<80), "He", IF(AND(E13="FEMALE", AH42>80),"",IF(AND(E13="FEMALE", AH42<80), "She", IF(AND(E13="MALE", AH42>80", ""))))
Please help.
(a) Cell E13 as Gender
(b) Cell AH42 as pupil's percentage.
I want a situation where if E13 is equal to "MALE or FEMALE" and the pupil's percentage is less than 80%, Cell A42 shows "He or she" depending on the gender selected in E13.
Then the second condition is that A42 will show nothing if AH42 is greater than 80%.
Below is the formula I used but it isn't working.
=IF(AND(E13= "MALE", AH42<80), "He", IF(AND(E13="FEMALE", AH42>80),"",IF(AND(E13="FEMALE", AH42<80), "She", IF(AND(E13="MALE", AH42>80", ""))))
Please help.