[Solved] Formula Help?
[Solved] Formula Help?
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
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
Last edited by Hagar Delest on Thu Feb 14, 2019 9:06 am, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.1
Mac OSX 10.9.5
Mac OSX 10.9.5
Re: Formula Help?
What happens if B30=B29? Why quotes about "0"? Why quotes about =B30-B29?
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Formula Help?
Search Help with function and learn how to use the Function Wizard.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Formula Help?
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
[Tutorial] Ten concepts that every Calc user should know
OpenOffice Spreadsheet Tutorial for Beginners with Examples
[Tutorial] Absolute, relative and mixed references
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: Formula Help?
Error 510, thank you for trying!RoryOF wrote:What happens if B30=B29? Why quotes about "0"? Why quotes about =B30-B29?
=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
Last edited by Mugs444 on Thu Feb 14, 2019 12:45 am, edited 1 time in total.
OpenOffice 4.1.1
Mac OSX 10.9.5
Mac OSX 10.9.5
Re: Formula Help?
I meant "what should happen if B30=B29?" This condition is not catered for in your initial attempt.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Formula Help?
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:RoryOF wrote:I meant "what should happen if B30=B29?" This condition is not catered for in your initial attempt.
OpenOffice 4.1.1
Mac OSX 10.9.5
Mac OSX 10.9.5
Re: Formula Help?
The problem with this formula is the second ==IF(B30-B29<0;"0";=B30-B29) shows Err. 510
Use
Code: Select all
=IF(B30-B29<0;"0";B30-B29)
Code: Select all
=max(0;B30-B29)
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Re: Formula Help?
The second option worked perfectly! Very simple and clean, thank you RusselB!
OpenOffice 4.1.1
Mac OSX 10.9.5
Mac OSX 10.9.5