(SOLVED) Help with IF function please

chrisd3 · Last edited by chrisd3 on Tue Oct 04, 2011 6:56 am; edited 1 time in total

Hi I have a problem. I have a formula that I am using and it is working fine but when I try to add it together in an IF the first part works okay but the second part doesn't. I know I'm missing something stupid but can't afford to spend any more time just going back and forth on this. Can someone please help???

The formula is

=IF(U3="Part Time";SUM(VLOOKUP(ROUND(AM9;2);'Dem Rate'.A$2:B$12;2);IF(U3="Full Time";SUM(VLOOKUP(ROUND(AM9;2);'Dem Rate'.D$2:E$12;2;0)))))

and like I say I know that the first part works ok - ie if U3 does say "Part Time", but when U3 says "Full Time" I get no answer. I've checked where everything points so it must be something in my formula. I think...... Please help
_________________
Trying. Always Trying.

gerard24 · Posted: Tue Oct 04, 2011 5:31 am Post subject:

Closing parenthesis of SUM at wrong place.
=IF(U3="Part Time";SUM(VLOOKUP(ROUND(AM9;2));'Dem Rate'.A$2:B$12;2);IF(U3="Full Time";SUM(VLOOKUP(ROUND(AM9;2);'Dem Rate'.D$2:E$12;2;0))))

Why SUM, VLOOKUP doesn't return a range ?
_________________
LibreOffice 3.5.0 on Windows Vista

chrisd3 · Posted: Tue Oct 04, 2011 5:41 am Post subject:

Thanks Gerard, however that doesn't solve my issue.

=IF(U3="Part Time";SUM(VLOOKUP(ROUND(AM9;2);'Dem Rate'.A$2:B$12;2;0)

=IF(U3="Full Time";SUM(VLOOKUP(ROUND(AM9;2);'Dem Rate'.D$2:E$12;2;0)

Both formulas work and give me what I want. The issue is joining them together, so the answer could be to IF part time or full time or false and this is where it falls down.

Any help appreciated
_________________
Trying. Always Trying.

gerard24 · Posted: Tue Oct 04, 2011 5:50 am Post subject:

Oups, i also put the ) in wrong place.

Right formula :

chrisd3 · Posted: Tue Oct 04, 2011 6:56 am Post subject:

Thanks Gerard got there in the end. Just missed out the middle 0 or FALSE and it worked. Thank you again.
_________________
Trying. Always Trying.