Make a cell with text white, if another cell has a value of 0%

Hello, I'm new. I have an issue that i can't figure out. In Excel, I have an invoice statement for my business that is almost complete. I have a section for a discount (for occasional use of course). Whenever the cell with the percent % has nothing in it or is 0%, i would like the cell next to it that has the word "discount" in it to be white. In other words, in cell m41 i would leave blank or put 0% in it, the cell to the left of it, L41 would have discount disappear. Then of course, percentage 1-100% i would like the word discount to appear. What formula would i use? or can that even be done in excel. Thanks guys!

You can use this formula in cell L41:

=IF(M41=0,"",Discount")

An alternative would be to use conditional formatting on cell L41 (which would contain the word Discount), such that the font colour is set to white if M41 is blank or contains zero. You may also want to have M41 to have a white font if it contains 0%, otherwise you would see 0% in that cell even though L41 appears to be blank.

Hope this helps.

Pete