Hello!
Can somone help me with this formula
2004:21-0-1-1-11 in this cell i wan't to get out "21"
2005:2-0-0-0-1 in this cell i wan't to get out "2"
My result from the formula is "-21" and ":2-" is there a formula that i can use on both and get the result "21" and "2"?
I want to add the together at the end and get the result "23" but with : and - i only get error.
The next problems is that i have copied some formulas from spreadsheet 1 to spreadsheet 2 these formulas are still reffering to spreadsheet 1. is there an easy way to fix that the formuals copied to spreadsheet 2 does reffer to the copied spreadsheet.?
Regards
Johhny
Bookmarks