Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting 2 conditions in a formula
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting 2 conditions in a formula
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Array formula and multiplying conditions | Excel Worksheet Functions | |||
MULTIPLE CONDITIONS FORMULA | Excel Discussion (Misc queries) | |||
Multiple conditions in a formula | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |