LinkBack URL
About LinkBacks
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks