I've just tried to remove the dev/0 warning but now I get the Circular Reference warning. The sheet still calculates correctly but I want to get rid of the warning...
[Code]=IF(Q94=0,"0%",N102/N98)[Code/]
This format is used on many of my cells but only a couple seem to show this error.
Can you see anything wrong with it?
Thanks
Hello 4lowie,
Try: =IF(Q94=0,"0%",IF(N98=0,"",IF(N102<N98,"",N102/N98)))
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
The CELL in which you are putting the formula should not be used in your formula.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hello 4lowie,
I notice that you have been back on the Forum again on 16 December 2013, without indicating if this issue has been resolved, with what Sixthsense and I had given you.
It would only be polite to advise the Forum if your issue had been resolved, and if so, then mark this thread as Solved.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks