I have a formula to calculate quantities in my sheet. However, the cells I refer to in the formula are also formulas. These will not always be populated with a number but need to be included in the calculations. Is there anyway I can do this so I don't get #VALUE as the return?
Thanks
Katie
You don't share with us your formula so generally speaking give a try to If(ISERROR.. function
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks