Hi Mike, Thanks for answering my questions. Now to answer yours. A Mulligan
in golf is when you take a shot over, usually when you didn't like the first
one. It is not legal :))

"MikeJohnB" wrote:

I agree with Pete on the circular ref to K5

However, when you sort out the equation, If you type a formulae into a cell.
Then click on that cell which is shown by a dark boarder appearing around the
cell. you will notice a little dot in the bottom right hand corner of the
cell you have clicked in which contains the equation.

If you carefully click and hold on that dot, drag the dot down 100 rows will
result in the formulae being copied down 100 rows.

I hope this helps a little??????

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Pete_UK" wrote:

You say that you want to subtract some values (including K5) and for the
total to also be in K5. Any formula in K5 which refers to itself will create
an error message, so could you re-phrase your question?

Pete

"onemulligan" wrote in message
...
I am new to Excel and am trying to make a formula for items I am selling.
After 2 hours of trying I am asking for help. I need starting entries in
E5
which has a price to then subtract G5,H5,I5,J5,K5 and have total in K5. I
would like this formula to work for 100 rows. I would also like to have
the
dollar sign show and two decimals show. Column B5,C5,D5 have text. If
someone would email me the correct formula and tell me where to paste it I
would greatly appreciate it. Thank you.