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;


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

    [h4]Cheers
    Andy
    [/h4]

Participate now!

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