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

[VioralK]

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!

[Pete_UK]

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

[VioralK]

Thanks man, the "IF" formula worked perfectly!! Have a wonderful day

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.