I can't figure out how to make a clean error-free formula for this situation.
(I'll be using this same kind of formula hundreds of times, so I need the formula to be simple as possible to reduce the time for calculating.)
Any help would be greatly appreciated!
If A$78 is a number THEN A$78
If A$78 is 0 THEN -0.01
If A$78 is not a number THEN C$23
If A$78 is not a number AND If C$23 is 0 THEN -0.01
If A$78 is not a number AND C$23 is not a number THEN "No Data"
Perhaps
Formula:
Please Login or Register to view this content.
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.
Try this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Sktneer,
I think your formula will work, but there's a problem when
A$78 and C$23 are both empty ("").
I need the formula to produce "No Data", but instead it produces -0.01
Do you know how I could fix that?
Thank you!
Originally Posted by sktneer
Last edited by lottidotti; 11-14-2013 at 05:42 AM. Reason: spelling mistake
OK. To achieve that you can try this formula......
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks