My IF Statement seems to be not quite right, help!

[Steven in Germany]

I have the feeling I'm making a silly mistake here. Here is my formula:

=IF(S33="";"";IF(P33="Deutschland";Q33+$AS$7;Q33+$AS$7+2))

What I would like it to do is the following

If S33 is 0 then give 0 as the result

If S33 is higher than 0 and P33 = Deutschland give me Q33+A7 as the result

If S33 is higher than 0 and P33 doesn't = Deutschland give me Q33+A7+2 as the result

Can someone put me out of my misery?

Many thanks!

 

[Joe4]

Perhaps:

[COLOR=#333333]=IF(S33=[/COLOR][COLOR=#ff0000][B]0[/B][/COLOR][COLOR=#333333];[/COLOR][COLOR=#ff0000][B]0[/B][/COLOR][COLOR=#333333];IF(P33="Deutschland";Q33+$AS$7;Q33+$AS$7+2))[/COLOR]

 

[philwojo]

You aren't checking for zero you are checking for "", which is blank. If you truly want to check for zero, then change the "" to 0 and try and see if it works.

 

[Steven in Germany]

That works perfectly, many thanks! Simple error, instead of "" I should have used 0, everything else was correct.