Multiple Formulas Help Request

[stephenoz]

Hi guys,

I'm working on a shared google doc spreadsheet for work, it just utilises data entry and drop down menus. I now need some more formulas however my knowledge is limited with more advanced formulas and I can't seem to work it out. If anyone has time to help, that be greatly appreciated. I have worked out google docs import removes data validation etc so I have fixed all of this up and now working directly from google docs.

Here is what I need. I tried to work this out myself using IF statements etc however wasted too much time and wasn't getting anywhere.

D8
I need a formula in D8 to report data in a cell (normally I use basic = sign), however I need it to check up to 3 cells. I want it to check AC8, if blank then check AA8, if blank then check last cell Y8. If data is in 1st cell, formula stops and just displays AC8 in cell D8. If all 3 cells are blank then I want D8 to show a dash. -

E8
Same rule as above however I want formula to check AD8, if blank then AB8, and finally Z8.


R8
Little more tricky. I want R8 to display Yes or No based on multiple selections from other cells, or to display - if other cells are empty.

In order for R8 to display YES, the following must be true:
I8 = Melbourne
P8 = One of the following selected from drop down box:
Australian Citizen
New Zealand Citizen
Permament Resident
Refugee
Asylum Seeker
Q8 = Yes

In order for R8 to display NO, the following must be true:
I8 = Sydney
P8 = Temporary Visa
Q8 = No


W8
Similar formula as above, checking multiple cells, W8 will display YES if True, or NO if false.

YES -
R8 = Yes
T8 = One of the following selected from drop down box:
High School
Certificate I
Certificate II
Certificate III
Certificate IV
V8 = One of following selected:
0
1

No -
R8 = No
T8 = One of the following selected from drop down box:
Diploma/Adv Diploma
Bachelor Degree
Postgraduate Degree
V8 = 2


Post formula here required for each cell as indicated above. If you need access to my test sheet to work out the formula, let me know. Thanks so much in advance.

[nimrod]

=if(isblank(ac8),if(isblank(aa8),if(isblank(y8),"--",y8),aa8),ac8)