Okay, thanks for feeding back.

Pete

On Nov 11, 12:41 am, "LabrGuy Bob R" wrote:
That's funny, just as I went to post that I found there was an issue with my
formatting and that the probelm wasn't really real you confimed what I have
read other places. thanks for taking the time, it's appreciated. The issue
was at my end so problem fixed....
Thanks
BOB

"Pete_UK" wrote in message

ups.com...



I don't quite understand. You could still subtract AC7 from AC8 (or is
it A7 from A8 ?), as they are not affected by the formula. You can
have something like:

... & TEXT(AC8-AC7,"#,##0.00") ...

within your formula if you need to subtract them and build them into a
text message as before.

Hope this helps.

Pete

On Nov 10, 10:01 pm, "LabrGuy Bob R" wrote:
=IF(AC8<AC7,"YES Credit for " & text(ac8,"$#,##0.00"),"NO Max Credit for
" &
text(ac7,"$#,##0.00")) ac8-ac7,"$#,##0.00

=IF(AC8<AC7,"YES Credit for "&TEXT(AC8,"$#,##0.00"),"NO Max Credit for
"&TEXT(AC7,"$#,##0.00"))
AC8-AC7
=IF(A8<A7,"YES Credit for "&DOLLAR(A8,2),"NO Max Credit for
"&DOLLAR(A7,2))
A8-A7

All three worked and very well, EXCEPT I now have formulas that use the
addition or subtraction of A8-A7 OR A8+A7, as I indicated above. I can't
get
it to work probably because I would think I need to make the calculation
in
another cell and only reference that cell. I've tried to put it in the
formula like I did above but it won't work. Probably because it's text
and I
can perform math on text...

Any ideas.
Thanks
BOB- Hide quoted text -

- Show quoted text -