Spreadsheet help

[NewsBot]

Anyone able to tell me what's wrong with this formula?:

 

http://ms-os.com/Themes/AlmostGlass/images/icon-quote.gif

OpenOffice.Org Calc wrote:

=IF((B3)AND(C3)AND(D3)AND(E3)AND(F3)AND(G3)1);then_"true";otherwise_"false"

 

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.

 

 

 

 

More...

 

View All Our Microsoft Related Feeds