Page 1 of 1
[Solved] Formula Help?
Posted: Wed Feb 13, 2019 4:57 pm
by Mugs444
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
Re: Formula Help?
Posted: Wed Feb 13, 2019 5:03 pm
by RoryOF
What happens if B30=B29? Why quotes about "0"? Why quotes about =B30-B29?
Re: Formula Help?
Posted: Wed Feb 13, 2019 6:58 pm
by John_Ha
Search Help with function and learn how to use the Function Wizard.
Re: Formula Help?
Posted: Wed Feb 13, 2019 11:42 pm
by robleyd
Re: Formula Help?
Posted: Thu Feb 14, 2019 12:27 am
by Mugs444
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
Re: Formula Help?
Posted: Thu Feb 14, 2019 12:31 am
by RoryOF
I meant "what should happen if B30=B29?" This condition is not catered for in your initial attempt.
Re: Formula Help?
Posted: Thu Feb 14, 2019 12:54 am
by Mugs444
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:
Re: Formula Help?
Posted: Thu Feb 14, 2019 1:25 am
by RusselB
=IF(B30-B29<0;"0";=B30-B29) shows Err. 510
The problem with this formula is the second =
Use
or as an alternative suggestion
Re: Formula Help?
Posted: Thu Feb 14, 2019 5:52 am
by Mugs444
The second option worked perfectly! Very simple and clean, thank you RusselB!