Posts by Amar

Re: 0 value Formula replace with text

Thank you for your help Andy,

Hi,

Im not sure if this can be done, but I am working on a spreadsheet, and in an instance where the value of a formula occurs, I want Excel to automaticaly replace this 0 result with a piece of text e.g "no hours left" etc

Any help is really appreciated
Thank you