Formula Query using AND

[Lise]

I have been using teh following which has worked really well
=IF('Overview Procedures'!A38="Construction",'Overview
Procedures'!J38%*100,"-")


But now I want to change it so that the calculation only happens if
!b2="ADM" and if !c2="PRO" otherwise the result will be -

Can anyone tell me what I'm doing wrong please

Thanks

Lise

 

[FSt1]

hi
your formula and request are a tad confusing but the syntax looks like
this....

=if(AND('Overview Procedures'!B2="AMD", 'Overview Procedures'!C2="PRO"
,'Overview Procedures'!J38%*100, "-")

careful. the formula wrapped.

regards
FSt1

 

[Lise]

Thanks for that but have copied (ignoring wrap) and still getting error re:
parentheses ?? sorry to be thick

Thanks

Lise

 

[FSt1]

hi
you're right, i did leave outa parentheses.
try this.....
=if(AND('Overview Procedures'!B2="AMD", 'Overview Procedures'!C2="PRO")
,'Overview Procedures'!J38%*100, "-")

sorry about that. and the formula should be all one line.

Regards
FSt1