help with excel

BRUTUS22

New Member
Joined
Mar 9, 2019
Messages
1
im a newby to excel ..trying to work something out.
If date in G1 = H1,then return yes in K1 and N/A in columns L1 to Q1
if false, leave k1 empty and allow input yes or no or n/a

date is dd/mm/yy

thanks in advance
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,696
Office Version
  1. 365
Platform
  1. Windows
If date in G1 = H1,then return yes in K1 , if false, leave k1 empty

Formula n K1
=IF(G1=H1,"yes","")

You cannot have values and a formula and allow input in L1 to Q1

But you can use data validation on those cells

Select L1:Q1 \ Data tab \ DataValidation \allow LIST \ source yes,no,n/a \ uncheck IgnoreBlanks \ OK
 

Watch MrExcel Video

Forum statistics

Threads
1,108,509
Messages
5,523,317
Members
409,511
Latest member
hitesh222002

This Week's Hot Topics

Top