It's That OpenOffice Spreadsheet Again

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

Reply to
the_constructor
Loading thread data ...

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

Reply to
Martin

Reply to
Martin

Reply to
Hugo Nebula

Reply to
John Whitworth

HomeOwnersHub website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.