Spreadsheet help

Joined
Jan 10, 2007
Messages
43,898
Location
In The Machine
Anyone able to tell me what's wrong with this formula?:

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
 
Back
Top