Formula help

[Harold R.]

OHRM 303 .xls
	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
32	41.50	5.50	0.00	0.00	0.00	40.00	0.00	2.50	0.00	1.50	0.00	0.00	1.50
January_05

Why is T40 returning It should be 0 I know I am missing something but i am brain dead.

 

[Harold R.]

I ment V32 I am brain dead.

 

[dsgs]

what's the formula in T40

 

[texasalynn]

edit - oh never mind since you changed you post
Ok I must be missing somthing be that is the correct answer

=SUM(O32,Q32:S32)-AA32
O32 = 41.50
Q32 = .00
R32 = .00
S32 = .00
-AA32= 1.50

Answer = 40.00

what are you seeing that makes you think it should be something else?

texasalynn

 

[Harold R.]

I am sory I had a wrong cell reference in V32 that was why I was getting the wrong answer. As I said I think I am brain dead today. I have another formula: =SUM(U32,V32,-AA32) it is returning a -1.5. How can I make it return a zero if the amount is less than zero?

 

[texasalynn]

I am sory I had a wrong cell reference in V32 that was why I was getting the wrong answer. As I said I think I am brain dead today. I have another formula: =SUM(U32,V32,-AA32) it is returning a -1.5. How can I make it return a zero if the amount is less than zero?

=if(=SUM(U32,V32,-AA32)<0,0,SUM(U32,V32,-AA32))

HTH
texasalynn