Hi,

I need a forumula to look at 3 cells A1,A2,A3 and if A1 shows a value greater than 0 then in B1 it will show "RADS", if A2 greater then 0 then B1 shows "UFH" and if A3 greater than 0 then B1 will show "FAN".

If all more than one of the A cells are greater than B1 will show more than one result.

Example:
A1 = 4
A2 = 2
A3 = 2

B1 = RADS UFH FAN

or

A1 = 4
A2 = 0
A3 = 2

B1 = RADS FAN

If A cells are blank then B1 will be blank.

Thanks

Jon