IF Statement

  • Thread starter Thread starter HS
  • Start date Start date
H

HS

Someone gave me some great ideas but I can't seem to make them work
=IF(COUNT(B1:C1)=2,"N","Y")
OR
=IF(AND(B1>0,C1>0),"N","Y")
If two blanks to be ignored
=IF(AND(ISBLANK(B1),ISBLANK(C1),"",IF(COUNT(B1:C1)=2,"N","Y"))
Click to expand...

what I have are three columns with $$$ in them and I need to tag them when
there is a value in only one of them with a Y

for example I need to populate Column D with a Y when Column B is the only
one populated


Column A Column B Column C Column D
190 150 90 N
100 Y
 
thank you, this is great! :)
Luke M said:
Something like this should work:

=IF(AND(ISBLANK(A2),ISBLANK(C2),NOT(ISBLANK(B2))),"Y","N")
if you're checking for blanks. If A & C are populated by formulas, maybe the
variation will work:

=IF(AND(A2=0,C2=0,B2>0),"Y","N")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
Click to expand...
 
=IF(COUNT(A1:C1)=1,"Y","N") entered in D1 and copied down.

Will return a "Y" if only one of the cells in A1:C1 is populated.


Gord Dibben MS Excel MVP
 
Back
Top