This is exactly what I did. Works great now!

"paul" wrote:

or have three columns
say column a is cost column b is desired markup column c is=a1*(a1*b1)
copy down and fil in as required
yum yum
--
paul
remove nospam for email addy!



"Paul Sheppard" wrote:


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

Hi Gonecoastal1

If cost is in cell A1 in B1 enter the following formula
=SUM(A1)/0.25, then format cell B1 as $

Change cell references to match your data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397123