Judgejulz

You keep adding to this ;-)

=IF(AND(S4="P",L4="Cir"),-P4,0)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"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?