IF Statement

bflan0524

Board Regular
Joined
Oct 7, 2016
Messages
173
need an if statement where columns A-D have either a 0, " ", or Y
i want a statement that says if any of them show a Y then return Y, else N
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,405
Office Version
  1. 365
Platform
  1. Windows
One way (example for row 1):
Code:
=IF(COUNTIF(A1:D1,"Y")>0,"Y","N")
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,405
Office Version
  1. 365
Platform
  1. Windows

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top