Excel Formula

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

What formula to use in excel if i want to find a value in particualr cell satisfying more than 1 condition.say,i have date range in column A,buyer range in column B and I have target value in column C.

Example- A1=1july b1=A&F c1=20
A2=1july b2=maggie c2=34
Nowif i want to find target value for A&F for 1july in column D,then what will be the formula.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not sure what you want


if you are asking about two "IFs" then

=IF(AND(<<cond1>>, <<cond2>>), <<show this for true>>, <<show this for false>>)