wmichael
Board Regular
- Joined
- Aug 26, 2014
- Messages
- 113
- Office Version
- 365
- 2019
- 2007
- Platform
- Windows
- Mobile
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),"")
I appreciate in advance any suggestions you have to remedy this matter.
Thank you.
=IF(R41=TRUE,Q41-(Q41*0.15),"")