E Ed from AZ Dec 15, 2008 #1 A cell formula is "=A1-1234.5". Is there a formula I can use in another cell to extract the "1234.5" from the formula? Ed
A cell formula is "=A1-1234.5". Is there a formula I can use in another cell to extract the "1234.5" from the formula? Ed
R RagDyer Dec 15, 2008 #2 Did you have a problem with your original post back in August? http://tinyurl.com/5s86lr
G google Dec 15, 2008 #3 If the formula "=A1-1234.5" is in B1, wouldn't putting "=A1-B1" in C1 give you the result you are looking for?
If the formula "=A1-1234.5" is in B1, wouldn't putting "=A1-B1" in C1 give you the result you are looking for?
G google Dec 15, 2008 #4 Uhh... if the formula "=A1-1234.5" is in B1, wouldn't putting "=A1-B1" in C1 give you the result you are looking for?
Uhh... if the formula "=A1-1234.5" is in B1, wouldn't putting "=A1-B1" in C1 give you the result you are looking for?
E Ed from AZ Dec 16, 2008 #5 Did you have a problem with your original post back in August? http://tinyurl.com/5s86lr Click to expand... Not at all - the problem was with my memory and failure to search the NG before posting!! Thank you for the pointer. Ed
Did you have a problem with your original post back in August? http://tinyurl.com/5s86lr Click to expand... Not at all - the problem was with my memory and failure to search the NG before posting!! Thank you for the pointer. Ed