close

Privacy guaranteed - Your email is not shared with anyone.

openoffice problem-my ignorance is killing me

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


  1. carbonblack

    carbonblack
    Expand Collapse

    Joined:
    Aug 13, 2003
    60
    0
    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):(
     
  2. David_G17

    David_G17
    Expand Collapse
    /\/\/\/\/\/\/\/

    Joined:
    Oct 7, 2002
    2,046
    0
  3. Cinic

    Cinic
    Expand Collapse
    Spongy Member

    Joined:
    Nov 17, 2001
    1,808
    56
    Location:
    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. Furant

    Furant
    Expand Collapse
    Millennium Member

    Joined:
    Oct 14, 1999
    441
    0
    Location:
    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. Cinic

    Cinic
    Expand Collapse
    Spongy Member

    Joined:
    Nov 17, 2001
    1,808
    56
    Location:
    Tempe, AZ
    Nice function...I'll have to use that.