AND vs. OR

K

Kiki

Can someone help with a cell formula? Here's preliminary,
but am I not using correct characters? for cell X2,If D32
= "I" AND E32 = "H" then insert value in C32 to X2.
Hope it's clear what I'm trying to do.
THanks
 
M

Michael J. Malinsky

=IF(AND(D32="I",E32="H"),C32,something else)

Replace the something else with whatever you want in X2 if the AND statement
is false.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Logical function 5
Formula please 6
Countif() 4
Conditional Formatting Amendment 2
Help with cell reference 3
Formula printing in cell 6
Condensing data from 3D to 2D 7
Personal Ledger Problem 2

Top