I have a sheet that I need to complete. I need to enter data where cells would popluate value based on criteria.
Example:
Criteria is male or female in cell A1
The follwing cells next to it would be based on male or female standards.
If its a male, they did 40 pushups then they get a perfect score of 100. Whereas if its a female, 25 pushups would get a perfect score off 100.
Any help would be appreciated!!!
Example:
Criteria is male or female in cell A1
The follwing cells next to it would be based on male or female standards.
If its a male, they did 40 pushups then they get a perfect score of 100. Whereas if its a female, 25 pushups would get a perfect score off 100.
Any help would be appreciated!!!
