recognising text problem

[legepe]

Merry Christmas all...
Can anyone please tell me how I can change this formula so it will not show "VALUE" when it detects text?

Please Login or Register  to view this content.

thanks
legepe

[jeffreybrown]

Not entirely sure what cell you want to look at for text, but a basic idea...

=IF(ISTEXT(Daily!G15),"#VALUE",Daily!G15*(1-$G$4))

[legepe]

Thanks for that, i modified it slightly and it works perfect... =IF(ISTEXT(Daily!H50),"OFF",Daily!H50*(1-$H$4))
However, i would like to round the numbers or results of this formula
can you please help me to do this

[jeffreybrown]

You have three choices >> Round, Roundup, or Rounddown...

http://www.excelfunctions.net/excel-...functions.html

=IF(ISTEXT(Daily!H50),"OFF",ROUND(Daily!H50*(1-$H$4),1))

[legepe]

worked a treat... thanks

[jeffreybrown]

You are very welcome and thanks for the feedback.