View Full Version : openoffice problem-my ignorance is killing me
I am trying to set a spreadsheet to calculate pricing, if for example c5=r5/.5+10, everything works fine. but should there be an empty reference cell,(r) the target cell(c) will display a 10. How do I get the target to stay blank? At my wits end, I don't know enough to figure it out. HELP!! (I know it's simple, but damn I am stuck):(
i would use an if statement to say if r5 does not equal zero, then the value in c5 is r5/.5+10
here's an example sort of like it in excel (i think it'll work in OO)
Is the cell blank or is it zero? It makes a difference.
These are for excel but they may work.
for blank cell =if(r5 = "", "", r5/.5 +10)
for zero entry =if(r5 = 0, "", r5/.5 +10)
Let us know if it works.
I agree with Cinic. Just wanted to add that you can use some of the spreadsheet's built in logic tests like this:
=IF(ISBLANK(R5), "", R5/0.5 +10)
Basically does the same thing as Cinic's first equation.
Nice function...I'll have to use that.
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.