In VBA trying to get the cell format to currency with the formula
I have the formula Below and would like to have the end results in the currency format. So when I enter $12.99 in the price cell I will get $15.47 instead of 15.46744. Thanks to any help I can get.
Function kaibetoegg(price)
kaibetoegg = (price * 1.056) + 1.75
End Function
Last edited by calebfrost; 07-02-2013 at 11:58 AM.
Perhaps:
will work?
Please Login or Register to view this content.
That solved it thanks. I was thinking it was going to be a little more complicated, that was simple.Originally Posted by yudlugar
Perhaps:
will work?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks