Developer Forum

1. New IFS interface (jfs.ifs, udf.ifs for example)

2. multiple ifs & ands indirect/offset...need help desperately pl

hi Shane...sorry - the folders are the inbox, selected etc. & the values are
the numbers under each. i will try to make a better example...i see it didn't
translate well below.

what i am doing is pulling numbers from a database and exporting them into
an excel spreadsheet which is my raw data/source file. the database is
broken down by the folders in which the candidates sit...inbox; scheduled for
interview;selected...etc. Source info is set up as in the table below:

Inbox Intv Sel Hird
city st jc
atl ga 123 55 30 17 10


from that i am populating a summary sheet for my clients which are assigned
multiple locations (cities) and titles (job codes).

So i have a client that is assigned atlanta, ga for customer assistants
which is job code 123...and i need to retrieve the number of candidates in
each folder/category in a snapshot/summary and i want to do this for each
location/client/job code

i need a formula to go out into the raw data to find the city...then look
for a specified job code then populate the cell below each category (inbox,
intv, sel, hired) with the corresponding number of candidates in each of
these categories. so that i can summarize each of my clients locations.

does that make sense?

3. multiple ifs & ands indirect/offset...need help desperately please

4. Multiple ifs, and ands, and are not working

5. Small (JFS.IFS or HPFS.IFS AutoCheck) install bump, Solved!

6. What does IFS="${IFS}[]()" mean?

7. IFs, ELSEs, END IFS -- proper construction

8. Ifs and Ands - I'm confused!

9. Multiple Nested IFs, ORs, Ands

10. IF's & AND's

11. Editing and Moviing from 6 If's to 7 Ifs (Nested)

12. "ifs", "ands" & "vlookups"

13. IFs ANDs and ORs

14. nested ifs and end ifs and elses

15. Bug in CDFS.IFS/UDF.IFS