Help if possible.

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

Originally Posted by VBA Noob

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.

Try this

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

VBA Noob

Originally Posted by VBA Noob

Try this

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

VBA Noob

God your good!

Bows down LOL

works perfect Thanks !