Negative Number Problem

[4 Barrel Harold]

Here is the problem I need help with, K60 changes constantly and 0nce K60 gets below 190 it starts giving negative Numbers. How can I fix this formula not to do that, Thanks 4 Barrel Harold

[/=IF(NOT(OR(K60>(K56+K48))),IF(K59>K60,K60-K56)*N13,K48*N13)CODE]



Here are the number that I'm currently using in the cells, any thing entered below 190 into K60 gives a neg no. Probably a simple fix like a ,0) at the end or something

=IF(NOT(OR(K60>(190+883))),IF((190+883)>K60,K60-190)*0.0091,883*0.0091)

 

[KolGuyXcel]

Try without the OR:

=IF(K60>(K56+K48),IF((K59>K60,K60-K56)*N13,K48*N13)

By the way, the original formula seems to lead only to K48*N13 part, always!

What values are we comparing using the OR?

 

[4 Barrel Harold]

KolGuyXcel
Hey I greatly appreciate you advice and you taking the time to get back with me, When I inserted your formula it didn't work like I wanted it gave me a True/False and #Value in cell. CGX I'm By no means a programmer so I don't know how to answer your question about where the formula is leading to LOL. Here is the original formula that I copied from offline =IF(NOT(OR(B6="red",B6="green")),C6*1.15,C6) Then I Pasted and played with it a few min to see if I could apply it to my sheet, after a few min I had tweaked the formula to this "=IF(NOT(OR(K60>(K56+K48))),IF(K59>K60,K60-K56)*N13,K48*N13)" So with that said I need the formula to not give a negative number when its finished calculating. So I tell ya what I do know in Ole Country Boy terms and if you of anyone else can fix and streamline it a bit I'd greatly Appreciate it.


I think that the part in-between the Quotes has to be rewritten =IF(NOT(OR(K60>(K56+K48))), """ IF(K59>K60,K60-K56)*N13 """" ,K48*N13)

Here's a mistake on my part I do see Now K59 is = to (K56+K48) which changes it to """ IF((K56+K48)>K60,K60-K56)*N13 """"
CORRECTION in the Code: I think that the part in-between the Quotes has to be rewritten =IF(NOT(OR(K60>(K56+K48))), """ IF((K56+K48)>K60,K60-K56)*N13 """" ,K48*N13)



I know that this part is checking the cells Greater Than/Less Than =IF(NOT(OR(K60>(K56+K48))),

So for Greater Than Part of it = K48*N13
which automatically calculates and inserts value, which works great

Now for the Less Than Part of it this is the part that's buggered up = """ IF((K56+K48)>K60,K60-K56)*N13 """"
and with the new if it checks again Greater Than/Less Than again. Now when K60=25 - K56=190 25-190= -165 which this negative number affects the over all total in another part of the workbook

 

[kvsrinivasamurthy]

Try this

=MAX(0,IF(NOT(OR(K60>(190+883))),IF((190+883)>K60,K60-190)*0.0091,883*0.0091))

 

[4 Barrel Harold]

kvsrinivasamurthy Thanks Just tried it out and it Works Great Greatly Appreciated 4bBarrel Harold