View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lise Lise is offline
external usenet poster
 
Posts: 102
Default Formula Query using AND

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