I am not a program and have limited understanding of excel but have been successful with past help so I thought I would try again. I hope I am attaching my spread sheet.
I need to create a function for cell E9 that will look at cell D4(gender) AND cell C5 (age in days) and choose the correct value J3:M3 (boys) or O3:R3 (girls) to subtract form cell C9.
I tried =IF(D4=2(AND(C5<E3,sum(C9,-5),FALSE)) but did not get anywhere. Any assistance would be greatly appreciated.
CI formula.xlsx
Bookmarks