I want to create a function in microsoft excel so that the answer of a calculation in the cell does not go below 0. If the answer to the calculation is above 0, then I want it to remain the same.
I.E. If the answer to the calculation of the cells is 20, then I want it to remain 20. If the answer is -5, I want it to alter it to 0.
Thanks.
2007-02-14 05:48:12 · 6 answers · asked by han 2 in Computers & Internet ➔ Software
=IF(your calculation >= 0,your calculation,0)
2007-02-14 05:54:41 · answer #1 · answered by Charles C 2 · 1⤊ 0⤋
Try this:
=IF(CELL REFERENCE=>0,"","0")
Cell reference has to be the cell with the calculation in...
The "","0" is important, the "","0" must be used.
Hope this helps and makes sense, I'm sure you will know what to do.
If this is really confusing I will make a picture (screen shot) and email to you
2007-02-14 05:53:22 · answer #2 · answered by Chεεrs [uk] 7 · 0⤊ 0⤋
In your calculation can you add IF function?
For example: = IF(calculation<=0, 0 ,calculation)
2007-02-14 06:00:43 · answer #3 · answered by beauty_sandy_lv 2 · 1⤊ 0⤋
nicely look, they're signed to a important label and they are mainstream yet they rap underground matters. you recognize, they rap actual. human beings imagine if that's horrorcore, political, or hardcore, then it should be underground. no longer real. like you stated, they don't get a lot hype. completely consider that. Yeah, Royce Da 5'9'' and Little Brother and both underground because they rap underground.
2016-11-03 10:54:29 · answer #4 · answered by Anonymous · 0⤊ 0⤋
You can just place this in the cell:
=max([your original formula],0)
Hope that's clear. It should be relatively painless.
2007-02-14 05:56:27 · answer #5 · answered by Web Maven 6 · 3⤊ 0⤋
do a global search and replace... put in search for -*, then replace with 0
2007-02-14 05:52:18 · answer #6 · answered by Anonymous · 0⤊ 0⤋