Setup using nested ifs (if) formula based on multiple conditions...

[Gihon]

Sample Data as follows. I am trying to setup the conditions as shown on a cell so they fill in the Category column. Thinking the ifs(if) function might be one way but I welcome other alternatives. Appreciate your help.

 

[Alex Blakenburg]

Can you just clarify what your logic.

1) As is stands it will only get past condition 1 if BOTH Fund and GS# are zero.
Are you sure that is what you are intending ?
It makes the statement "Funder OR GS# = 0" redundant on the other lines (and if its meant to be descriptive would be Funder AND GS# = 0)

2) It looks to me like Main values should be in a lookup table
But lets sort out item 1 first

3) Your numbers are all left aligned, what is the source of your data ? Are they numbers or text ?
Use either =isnumber or =istext if you are not sure and let us know.

If possible can you change your picture to XL2BB ?