Hi..
I have a excel chart for the hole year.. I dont hae data for the rest of the year, but i dont want the chart to drop to 0 on the weeks with no data.
I have seen a lot of places on google that i should replace my 0 with #N/A, but it stil dosent work..
=IF(AW9="";NA();AW9/AW15)
Anyone who can tell me what im doing wrong?
try =IF(AW9="";0;AW9/AW15) instead
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
that dosent work :/
well actually in that formula you are taking a space and changing it to a zero then trying to divide the zero by some other number which will likely not result in anything you can use. I was just giving you a way to replace the space with something other than NA.
What is in those cells, or better yet what are you trying to accomplish?
i have a chart that show some types of failure we have in the company.
I want it to be as automatic as posible, so when i type in the data the chart shows what i want it to show without i have to drag the line manually so the new data is in the chart..
does it make any sense?
I tried the formula with fake data and mine worked so unless I misunderstood your regional settings (; instead of ,) it should work.
hmm maybe i need to make a new chart and see if it works
gotta head to work, will check back once I get there but someone will likely stop by to help you if I can't.
i hopenice day to you
I have some limited access from work by an iPad only. Do you still have the issue?
I made a new chart, and it works fine now
The other chart was a couple of years old, so maybe there was some settings i was missing
but thanks for your time and help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks