Excel Formula

Closed
sunita - Jul 13, 2010 at 08:04 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2010 at 08:12 AM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 13, 2010 at 08:12 AM
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>>)
0