1. Welcome Guest! In order to create a new topic or reply to an existing one, you must register first. It is easy and free. Click here to sign up now!.
    Dismiss Notice

Spreadsheet help

Discussion in 'Microsoft News' started by NewsBot, Apr 2, 2008.

  1. NewsBot

    NewsBot I Got News

    Joined:
    Feb 8, 2006
    Messages:
    1,813
    Operating System:
    Windows Vista Home Premium
    Anyone able to tell me what's wrong with this formula?:

    <blockquote>.<b>OpenOffice.Org Calc wrote:</b><i>=IF((B3)AND(C3)AND(D3)AND(E3)AND(F3)AND(G3)1);then_"true";otherwise_"false"</i>[/quote]

    I'm trying to put TRUE as the test for cells B>G but OO keeps changing it to 1.

    All the cells I put it in read "#name?"

    Man, I should get a decent office suite.
     
    Last edited by a moderator: Feb 2, 2014
    NewsBot, Apr 2, 2008
    #1

Share This Page