Hi
and what is your expected 'combined' result in column C?

--
Regards
Frank Kabel
Frankfurt, Germany
"James W." schrieb im Newsbeitrag
...
I have an array of numbers and am trying to see if the Mod of two of these
number is less than 1. I have a long list so making a nested if function
would be my last option.

Example

a b wishfull results
1 1.20 combine
2 1.00
3 2.00
4 1.50 combine
5 2.90

Thanks in advance.