Two Criteria = 1
Thank you. This is excellent.
"Pete_UK" wrote:
Try this:
=IF(AND('Sheet1'!J4="Apples",'Sheet1'!K4="10"),1," ")
Note that by putting quotes around the 10 you are making Excel treat
it as a text value. If K4 contained the number 10 then the formula
would fail.
Note also that curly braces { and } have a special meaning in Excel
related to array formulae, so you should not use them - they'll just
cause confusion.
Hope this helps.
Pete
On Aug 14, 11:06 pm, 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.
|