Previous Topic Next Topic

Formula help

Closed
KRICO14 Posts 1 Registration date Thursday August 8, 2013 Status Member Last seen August 8, 2013 - Aug 8, 2013 at 01:33 PM
 Blocked Profile - Aug 8, 2013 at 02:15 PM
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

Answer 1 / 1
Blocked Profile
Aug 8, 2013 at 02:15 PM
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
Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses