Need existing formula to show blank cell if another cell is blank.

[Oryan77]

I have two formulas that need the same function.

In cell H7, I have the following formula:

=IF(F7="","",ROUNDDOWN(((W47*N7)+(X47*N9)+(Y47*N11)+(Z47*N13)+(AA47*N15)+(AB47*N17)+(AC47*N19)+(AD47*N21)+(AE47*N23)+(AF47*N25))/F32*(J7/100),0))

I need to change that formula so that if cell F7 has a value, but cell D7 is blank, then cell H7 will stay blank.

The second formula in cell R7 is:

=IF(P7="","",IF(F30>(P7+8),"",IF(F30<(P7-8),"0",ROUNDDOWN((N7*W37)/IF(F32=0,1,F32),0))))

I need to change that formula so that if cell P7 has a value, but cell N7 is blank, then cell R7 will stay blank. Thank you!

 

[Michael M]

Try using

=IF(AND(F7<>"",D7=""),"",ROUNDDOWN(((W47*N7)+(X47*N9)+(Y47*N11)+(Z47*N13)+(AA47*N15)+(AB47*N17)+(AC47*N19)+(AD47*N21)+(AE47*N23)+(AF47*N25))/F32*(J7/100),0))

I'm sure you can handle the 2nd question yourself based on the answer provided

 

[Oryan77]

Try using

=IF(AND(F7<>"",D7=""),"",ROUNDDOWN(((W47*N7)+(X47*N9)+(Y47*N11)+(Z47*N13)+(AA47*N15)+(AB47*N17)+(AC47*N19)+(AD47*N21)+(AE47*N23)+(AF47*N25))/F32*(J7/100),0))

I'm sure you can handle the 2nd question yourself based on the answer provided

Thanks, that seems to work, however, now if cell F7 is blank, I get #N/A as a result in cell H7. How do I tweak this so H7 stays blank if F7 is blank? Sorry if I should have mentioned that before. I wasn't aware it needed to be brought to attention.

In case this also needs mentioning, cell H7 also needs to stay blank when cell D7 is blank. If cell D7 has data, but cell F7 is blank, then H7 still needs to stay blank. I didn't mention any of this before because the original code was already working like that before your addition. I apologize if this was important to know beforehand.

 

[Michael M]

Maybe then

=IF(OR(F7="",D7=""),"",ROUNDDOWN(((W47*N7)+(X47*N9)+(Y47*N11)+(Z47*N13)+(AA47*N15)+(AB47*N17)+(AC47*N19)+(AD47*N21)+(AE47*N23)+(AF47*N25))/F32*(J7/100),0))