Apache OpenOffice Community Forum

Hi there,

This may be very simple, but I don't know how to search for it properly because I can't seem to find the answer.

I want to use a conditional format, but if the value is greater than 0, I'd like the answer to the equation to show, not the equation. Here's what I have now:

=IF(B30-B29<0; "0";IF(B30-B29>0;"=B30-B29")

and what shows in the cell is =B30-B29, but i'd like the answer to show, not the equation...

Thank you!

Mugs

What happens if B30=B29? Why quotes about "0"? Why quotes about =B30-B29?

Search Help with function and learn how to use the Function Wizard.

If you are new to spreadsheets, you may find the following to be useful resources.

[Tutorial] Ten concepts that every Calc user should know

OpenOffice Spreadsheet Tutorial for Beginners with Examples

[Tutorial] Absolute, relative and mixed references

RoryOF wrote:What happens if B30=B29? Why quotes about "0"? Why quotes about =B30-B29?

Error 510, thank you for trying!

=IF(B30-B29<0;"0";"=B30-B29") shows =B30-B29 in cell....

=IF(B30-B29<0;"0";=B30-B29) shows Err. 510

I don't know. I've looked on attached links, but am not find much about conditional. Function wizard says

IF Test; Then_Value; Otherwise_Value

I meant "what should happen if B30=B29?" This condition is not catered for in your initial attempt.

RoryOF wrote:I meant "what should happen if B30=B29?" This condition is not catered for in your initial attempt.

It won't! I'm trying to track my writing. I have a daily goal of 1500 words. I wanted to set up a weekly goal of 10500, so if I have a bad day, I still am pushing for a 100% week. But right now rather than saying something like 40% or whatever it would be, it says -276% because the empty formula spot shows -32714 words. So here is my excel sheet:

=IF(B30-B29<0;"0";=B30-B29) shows Err. 510

The problem with this formula is the second =
Use or as an alternative suggestion

The second option worked perfectly! Very simple and clean, thank you RusselB!