"Mangesh Yadav" wrote:

=1/25%

should help, or is it that you want a UDF

Function MyFun(a,b)
MyFun = a / b
End Function

Usage:
=MyFun(1, 25%)


Mangesh




"Gonecoastal1" wrote in message
...
Trying to simplify menu costing. Can anyone help? I know this should be
simple but it is late...I appreciate the help!

I'm setting up a spread sheet where an appetizer item is mini spring rolls. My cost is 1.54. I want to keep the food cost on this at 25%. But I also have dessert on here at 2.41 cost that I want at a 40% markup. I want the spreadsheet to cost at what ever mark up I put in. Make any sense?