[Solved] "IF" Function

[stanco]

Prior to using Open Office Calc, I was using QuatroPro which is similar to Excel. In the past, I was able to use the "IF" function as in the following example:
@IF(C74-C73<O,O,C74-C73)

This formula is to return the result as zero if the result in C74 is less than C73. However, the formula does not work for me in Calc. Can you tell me what I'm doing wrong?

[RonIA]

Not being familiar with Quattro Pro, I would guess two things syntactically.

Instead of @ use = in front of your formula. Secondly use semicolons instead of commas.

I would also say you could make it simpler by just saying:

=IF(C74<C73;O;C74-C73)

[stanco]

Ron1A

Thanks for your response.
Sorry, but I tried substituting your formula and the result show as"#NAME?" Don't really know what this means.

Stanco

[RonIA]

I guess the next thing is, what values are in the fields you are comparing?

[Hagar Delest]

I think the problem is in the formula : =IF(C74<C73;O;C74-C73). It should not be an 'O' (the letter) but a '0' (zero).

Code: Select all

=IF(C74<C73;0;C74-C73)

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.

[RonIA]

Thanks for that catch. I just copied and pasted the OPs formula and dropped the calculation in the comparison. I did wonder about the O vs 0, but onscreen I couldn't tell for sure. I bet that works.