I'm inputting values manually each day when I get them and formulating averages, percentages, etc. I the respective cells with the formulas to compute ONLY when I input a value in...right now I have to drag the formulas down and it looks like below, which drives me crazy--please help!!
2.74%
-3.26%
-13.19%
0.35%
21.13%
-0.29%
-100.00%
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
=If(denominator_of_your_formula=0,0,your_formula)
where denominator is what you have in the denominator of your formula...
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks, what about the numerator?
Is there a way it to get it to not return anything instead of the 0?
You mean?
=If(denominator_of_your_formula=0,"",your_formula)
You're the man!! Thank you!
For some reason, now I'm having another issue...I have conditional formatting set on this cell so if the value is over .1 it turns blue...now all the cells are turning blue even though they have nothing in them?? Any idea why or what I can do? I really appreciate your help!
If you CF is something like:
Cell Value Is >> greater than >> =0.1
or
Formula Is >> =A1>0.1 where A1 is the cell to format...
then it shouldn't highlight blanks....
Yea that's what I thought??
rkrieg, I don't think you read the last post right.
If your current CF is ">0" change it to ">0.01" then it won't highlite blanks.
yea that's what it's set up as...
if cell is > .01 then highlight blue...
for some reason it's highlight these ones blue still which is odd?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks