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