Hi there..
Just wondering if anyone knows the formula to search a sum for a value.
e.g
A1 =9+4.5+7.3
what would the formula be to search cell A1 to see if it contains the value "7.3"?
I tried this with no luck![]()
=ISNUMBER(SEARCH("7.3",A1))
Regards
Chris
Bookmarks