Help 2 this Formula (if and) or

[Hjemmet]

Hey Group

I need some Help to this formula

=IF(And(D9=1;L11=1);D12)

That Part Works Fine

i now need a "Or function after that Working formula so it might look like that perhaps

=IF(And(D9=1;L11=1);D12)or If(And(D9=1;L11=2);D11)

i have try that but it wont Work

and not for any thing i know the Formula will If i get it to work it will end up to 8 Or functions

hope that was enough Info

 

[Scott T]

Is this what you want?

=IF(AND(D9=1,L11=1),D12,IF(AND(D9=1,L11=2),D11))

Note since you have now false value if both conditions are false then FALSE will be displayed.

 

[Hjemmet]

Thanks for Try to help but it wont work

and i can see you have used "," in the formula My Office 2016 Danish version wont alow "," but ";" this one instead

 

[Fluff]

What happens if you change the commas to semi-colons?

 

[Hjemmet]

i got this error code #Name ?

 

[Fluff]

Replace the IF with HVIS
and the AND with OG

 

[Hjemmet]

Yabba Dabba DOHHHHH Now it's Work

thanks For the Help

My mistake not to have Take Notice of the Language