newbie question

M

matt

If I have a formula of five numbers, all of which are being added
together; how do I write a formula in another cell that will subtract
the third number in the previously mentioned formula from a number
that has already been entered into the cell?

Thanks!
 
J

Jim

Alternatively you can use the split" command using the plus sign as
the delimitor to create an array and use the third element. You will
need to trim the spaces and convert the string to integers, single or
double
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top