I tried using this based on another post
=(IF(C5="Jim",H5*27.5,IF(C5="Don",H5*29,IF(C5="Francisco",H5*25.5,IF(C5="Cristobal",H5*16,IF(C5="Paulino",H5*19,IF(C5="Alex",H5*19,IF(C5="","",)))))))&IF(C5="Joe",H5*15,IF(C5="Martin",H5*28.5,IF(C5="Ernesto",H5*16,IF(C5="","")))))
but keep getting this as an example
159.5FALSE
I am sure I just missed something small somewhere in there.
Thanks in advance!!
=(IF(C5="Jim",H5*27.5,IF(C5="Don",H5*29,IF(C5="Francisco",H5*25.5,IF(C5="Cristobal",H5*16,IF(C5="Paulino",H5*19,IF(C5="Alex",H5*19,IF(C5="","",)))))))&IF(C5="Joe",H5*15,IF(C5="Martin",H5*28.5,IF(C5="Ernesto",H5*16,IF(C5="","")))))
but keep getting this as an example
159.5FALSE
I am sure I just missed something small somewhere in there.
Thanks in advance!!