VBA Noob Wrote:
Hi,

Not sure why you want to mox days with $ but this should do the trick

=IF(C1-A1+1=15,TEXT((C1-A1+1)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&"
Days")

I added Days and $ text so you can tell which is which

VBA Noob
Sorry maybe I confused you

I want to show a dollar value after the total of days but I only need
the value to multiply after 15 days for instance

the trailer came in on 6/30/06 its now 7/16/06 so 16 days have went buy
so the total would be $15 then tomorrow it would be $30 and so on

also I ran into another problem but I'll wait to ask that LOL.. sorry
guys if I am being a pain.


--
bgjon5
------------------------------------------------------------------------
bgjon5's Profile: http://www.excelforum.com/member.php...o&userid=36410
View this thread: http://www.excelforum.com/showthread...hreadid=561866