|There are a few issues with mikelinus's suggestion...|
1 - A simple subtraction operation does not need the SUM function.
Typically =K23-K20 would be all that is needed, but not in this case for 2 reasons. Read on...
2 - "need formula to subtract 84.16 from 3733.84"
That would be written as =K20-K23, the opposite of what mikelinus suggested, but I don't think that will work either. Read on...
3 - If the "space D" is actually in K23, then you can't use a simple subtraction formula. The "space D" will cause Excel to see the contents of K23 as Text. You need to extract the number portion before you can perform any mathematical operations.
That formula will use the FIND function to extract the characters before the "space". Once those characters are extracted, Excel will treat them as a number, not Text.
Let us know how that works out for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03