Formula Help
Amy,
Try this
=IF(AND(C2="x",B2="d"),D2*21%,"")
Mike
"Amy" wrote:
I need to write a formula in excel that says the following:
If C2 = "x" and B2 = "d", then D2*21%
I can get the first part using the IF function, but I am only allowed 1
logical test - how can I use 2?
Thanks!!!!
|