formula not recnogizing cell

[purook02]

I have the following formula =ROUNDUP(SUM(R70:V70),0)

This formula is not recognizing cell U70 in a specific instance.

my formula is cell U70 is longwinded =IF($U$64="KEYSTONES 2 x 2","Included",IF(((J70+K70)*U$61)+((J70+K70)*U$62)<50,"$50",IF(((J70+K70)*U$61)+((J70+K70)*U$62)>50,ROUNDUP(((J70+K70)*U$61)+((J70+K70)*U$62),0))))

When this formula equals less than 50, i'm forcing it to be $50.

When this instance happens the first formula at the top doesn't recognize the $50. Any ideas why this is happening and how to resolve it?

 

[Joe4]

The issue is the "$50".
When you enclose a number in quotes, it is treated as Text and not a number and will not be included in the Sum.
Change it to 50 (no quotes).
If you want the dollar sign to appear, just use Currency Formatting on the cell.

 

[purook02]

I knew it was something dumb on my part. thanks!

 

[Joe4]

You are most welcome!