Formula help for value grater than 0 placing a name

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

I wanting D1 to show a name if there is a value grater than 0 in B. A 1,2
and 3 always stay the same. If B1 is grater than 0 D1 should say Brown. If
B2 is greater that 0 D1 should say Jill. If B3 is greater than 0 D1 should
say Richard. B 1,2 and 3 will only have one of them grater than 0.


A b c d
1 John 0 Richard
2 Adam 0
3 Sam 2

Thanks
 
Back
Top