I dont know a whole lot about excel, but this seems straight forward - yet I can't get it to display properly
=IF(F4="F","",H4*(IF(F4="M","0",H4))*(IF(F4="", "", H4)))
Basically F column is tracking Male or Female, M = 0, F = a blank cell
However continuing on down the page, If I havent typed M or F in the F column and the cell is blank, I want the output to remain blank in H column. Under the current formula its giving me 0 if blank, or M and F works fine displaying nothing.