Thread: If And Or
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
K11ngy K11ngy is offline
external usenet poster
 
Posts: 31
Default If And Or

Trying to nest a statement together but have problems

I need to:

If A1 and A2 = pass then Full award, Else ""

I also need to nest in for example

If A1 = pass or exempt and a2 = Pass, Exempt then full award else ""

Cant seem to fathom it

Thanks for help

Steve