View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
judgejulz judgejulz is offline
external usenet poster
 
Posts: 8
Default putting 2 conditions in a formula

Does anybody know how I can enter a formula on the condition of the contents
of 2 different cells?

For example:

I want AE4 to equal -P4, but only when S4='P' AND L4= 'cir'

Anybody got a formula?