close

Privacy guaranteed - Your email is not shared with anyone.

## Welcome to Glock Talk

• Converse with other Glock Enthusiasts
• Learn about the latest hunting products
• Becoming a member is FREE and EASY

If you consider yourself a beginner or an avid shooter, the Glock Talk community is your place to discuss self defense, concealed carry, reloading, target shooting, and all things Glock.

# openoffice problem-my ignorance is killing me

Discussion in 'Tech Talk' started by carbonblack, Oct 12, 2004.

1. ### carbonblack

60
0
Aug 13, 2003
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)

Oct 7, 2002

3. ### CinicSpongy Member

1,834
70
Nov 17, 2001
Tempe, AZ
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.

_John

4. ### FurantMillennium Member

441
0
Oct 14, 1999
Roswell, GA
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.

5. ### CinicSpongy Member

1,834
70
Nov 17, 2001
Tempe, AZ
Nice function...I'll have to use that.