0 value Formula replace with text

Amar · Jan 10th 2005

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

**Andy Pope** · Jan 10th 2005

Re: 0 value Formula replace with text

Hi Amar and welcome.

You need to test the formula first and output the formula result or you message.
Something like;

Code

=IF((A1*2)<=0,"None left",A1*2)

Amar · Jan 10th 2005

Re: 0 value Formula replace with text

Thank you for your help Andy,

0 value Formula replace with text

Participate now!

Share