4 replies
by gurnerworld
Can you use an If statement?
Something along the lines of
=if(field1="","",(field1*field2))
This will work in standard worksheet calculations and I think it will work in calculated fields - if it doesn't, then I apologise.
There is a function within Excel which is designed specifically for this problem which you might also like to try, which is ISERROR.
Hope this is useful.
by hvanegas
by gurnerworld
Addition to the previous answer:
If the calculated field is January/february then the following will only do the calculation if it doesn't produce an error.
=IF(ISERROR(January/February),0,January/February)
The formula will return a zero ifthe calculation would return an error. I can't get it to return text - can someone else help here?
by hvanegas
This discussion is closed to new replies.
Trending After Hours posts
Sort by Trending