newbie question

  • Thread starter Thread starter matt
  • Start date Start date
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!
 
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
 
Back
Top