Assume the dash in front of P4 is a minus sign:

=-AND(S4="P",L4="cir")*P4

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"judgejulz" wrote in message
...
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?