Previous Topic Next Topic

Excel Formula

Closed
sunita - Jul 13, 2010 at 08:04 AM
rizvisa1 Posts 4478 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.

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response