It's That OpenOffice Spreadsheet Again

Nov 13, 2009 4 Replies

Oh boy, I wish I was clever.



Using open office spreadsheet. Is it possible to introduce a statement into a cell something like this:



Cell c15:



=(b7+b13)*.05 IF answer is x = > .005 then let x = .01 IF x


In Excel (and OO should be the same or very similar), then enter in cell C15...

=IF((B7+B13)*0.05>=0.005,0.01,0)

In your post, you have " >= and

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required