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
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
Have something to add? Share your thoughts — no account required.
Ask the community — no account required