Blank cell value to be taken as zero in the formula

[pbrayudu]

Sir,
I am using the formula to calculate weighted average as explained below.
Value of Cell D9 = 23
Value of Cell E9 = 20
Note: D9 and E9 Can take any value.
Formula in F9 Cell is: =ROUNDUP(((MAXA(D9,E9)*2)+(MINA(D9,E9)))/3,0)
Answer in F9 Cell is: 22

My requirement is that I need the formula in such a way that "if the cell D9 or E9 is blank or both are blank, the blank cell value is to be taken as Zero by the formula". The formula shall work by taking blank cell value as "zero". Please modify / provide me the formula with this requirement.
Hope I could explain clearly.
Thank you in advance for the help
Best Regards
P Bangaru Rayudu

 

[jasonb75]

This should do it.

=ROUNDUP(((MAXA(D9,E9)*2)+(IF(COUNT(D9,E9)=2,MINA(D9,E9),0)))/3,0)

 

[pbrayudu]

Thank you Sir,