Is multiple IF statements what I'm looking for?
Hi,
Am Thu, 12 Jun 2014 17:01:41 +0100 schrieb Synapses:
I have numbers in the columns and want to say if columns 1 and 3 match
and columns 2 and 4 match, then the fifth column should have YES, but if
columns 1 and 3 match and column 4 is greater than or less than column
2, then the answer should be MAYBE. Hopefully this makes sense!
try:
=IF(AND(A1-C1=0,B1-D1=0),"yes",IF(AND(A1-C1=0,B1-D1<0),"maybe",""))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|