Previous Topic Next Topic

Formula help

Closed
KRICO14 Posts 1 Registration date Thursday 8 August 2013 Status Member Last seen 8 August 2013 - 8 Aug 2013 à 13:33
 Blocked Profile - 8 Aug 2013 à 14:15
Hi,

I'm looking for a formula for the following scenario:

Worksheet 1
Cell A
129622

Worksheet 2
Cell A Cell B Cell C
129622 1,000 35

I need a formula that would return the value in Cell B (Worksheet 2) If cell C (worksheet 2) is less then or equal to 70 AND Cell A (both worksheets) match.

Does that make sense?

Thanks!

1 response

Réponse 1 / 1
Blocked Profile
8 Aug 2013 à 14:15
Hey try this....hopefully not doing your lab work for you!

=IF(AND(Sheet2!C1<=70,Sheet1!A1=Sheet2!A1),Sheet2!B1,FALSE)

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