Two Criteria = 1
This is superb! Thank you.
"David Biddulph" wrote:
IF(AND('Sheet1'!K4="10",'Sheet1'!J4="Apples"),1,"" )
or
IF(AND('Sheet1'!K4="10",J4="Apples"),1,"")
depending on whether your J4 is on sheet1 or on the current sheet.
Note that you are checking for K4 containing the text string "10"; if you
want to check for the number 10, change it to
IF(AND('Sheet1'!K4=10,'Sheet1'!J4="Apples"),1,"")
--
David Biddulph
Jazz wrote:
I am looking for help with a formula. Write now if Sheet1 has a "10"
in cell K4, and I put this formula {=IF('Sheet1'!K4="10",1,""} in
cell P4 the number "1" will be displayed in cell P4. I wanted to
modify the formula so that if cell J4 displays "Apples" and K4
displays "10" (assuming I put the formula in P4 again) a "1" will be
displayed in cell P4. Thank you for your ideas.
|