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]

A very minor edit to your formula (as long as R41 os only ever TRUE or FALSE):

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

 

[wmichael]

A very minor edit to your formula (as long as R41 os only ever TRUE or FALSE):

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

Thank you for your help!

 

[Joe4]

You are welcome.

The key is the structure of the IF function, which has three arguments:
=IF(condition, what to return if condition is true, what to return if condition is false)

 

[wmichael]

You are welcome.

The key is the structure of the IF function, which has three arguments:
=IF(condition, what to return if condition is true, what to return if condition is false)

@Joe4, I also want to add a second condition. =IF(R41=TRUE,Q41-(Q41*0.15),0) and if K41=x. Might you have any thoughts about how to do this? Thank you.

 

[Snort]

=IF(AND(R41=TRUE,K41="x"),Q41-(Q41*.15),0)

 

[Georgiboy]

You can also drop the '=TRUE' part if you wish as:

=IF(R41,"Yes","No")

Will calculate the same as:

=IF(R41=TRUE,"Yes","No")

 

[wmichael]

You all made my day! Thank you all for your help on this.

 

[Joe4]

Glad we were able to help!

Note that when marking post as the solution, you want to mark the post that answers your original question (and not any follow-ups and variations).
The way that it works is that when you mark a post as the solution, it shows the initial question at the top and the solutionjust below it. So if the solution answers something that wasn't asked in the original question, it doesn't make much sense.
I went back and changed it back to what you had originally. You can "Like" as many replies as you want in a thread, but only one post can be marked as the "Solution".

 

[wmichael]

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