If/And Complications

[Monkofnee]

Hi, new here, but I see that this is a great place to get help with Excel 2016.

I'm trying to get column D to report Telework, Site, Regular leave, Special leave or Mixed based on what is entered in columns G:J.

I've tried using If/AND but it gets complicated very quickly.

Here are the results I'm looking for:



Telework should show up in D if hours were only input to the E Hours Teleworked column

Site or Field should show up in D if hours were input only to the Hours work On Site or in Field

Regular Leave should show up in D if hours were input only to the Regular Leave column

Special Leave should show up in D if hours were input only to the Special Leave column

Mixed should show up in D if there is any combination of hours input across more than one column
Thanks so much for your help.

[Paul]

Perhaps this will work?

Please Login or Register  to view this content.

[Fluff13]

Hi & welcome to the board.
How about
=IF(COUNTIF(G2:J2,">0")>1,"Mixed",IF(G2>0,"Telework",IF(H2>0,"Site or Field",IF(I2>0,"Regular leave",IF(J2>0,"Special leave","")))))

[Monkofnee]

Thanks for both those answers. They do just want I needed.

[Fluff13]

You're welcome & thanks for the feedback