4

Here is the statement

=IF(L7>7,"$500",IF(L7>11,"$1200",IF(L7>15,"$2000",$0)))

I simply need this to resolve a value based on the set conditions. I've tried numerous variations but can't seem to get the second or third results.

Unsure if there is something that libreoffice needs that differs from excel format.

I should also state that the cell L7 is using the COUNTA function to get its result.

1 Answer 1

5

From what I can see, you have a missing quote:

=IF(L7>11,"$500,IF(L7>11,"$1200",IF(L7>15,"$2000",$0)))
               ^                                  ^
               +---- here ------------------------+

but I suppose that's just what you entered here on SuperUser.

That being said, I think your mistake is that you need to test with the highest number first:

=IF(L7>15,"$2000",IF(L7>11,"$1200",IF(L7>11,"$500","$0")))
                        ^                ^
                        +----------------+

However, the double limit of 11 means you'll never get $500 in your output.

The quotation around the numbers are also not required:

=IF(L7>15,2000,IF(L7>11,1200,IF(L7>11,500,0)))

Then make that one field a $$$ field (usually called money fields).

3
  • I'll try this at the office tomorrow and let you know if it works.
    – Val
    Jun 29 at 3:27
  • Just tried your function and it returns a TRUE statement instead of a value. By adding the quotation marks back in the function works as intended. Thank you for your help sir!
    – Val
    Jun 29 at 12:59
  • I tested, just in case, and it works in my version... I don't think that the field can be mode to show a boolean. Jun 29 at 17:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.