Help-How to return a zero if a cell = FALSE

[wmichael]

Hello. This formula is used to copy the amount of Q41-15% if TRUE is working, but I also want to return a zero if R41=FALSE so the cell is not empty.

I appreciate in advance any suggestions you have to remedy this matter.

Thank you.

=IF(R41=TRUE,Q41-(Q41*0.15),"")

 

[Joe4]

@Joe4 I used your tip to update the post. Thanks again!

Hmmm, while that post is helpful in explaining how it works, I think post #2 is the one that most directly answers the original question you asked.