0 value Formula replace with text

  • 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

  • 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;

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


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!