I relatively new to excel and would like help on the following. I would like to check a cell and if it has a value in it, check a second cell. If the first cell has a value, then the second cell is required. If the second cell is blank, would like to display an error message.
Please see attached example.
Thanks, Ron
Last edited by Ron1121; 12-18-2009 at 05:22 PM.
Hi,
Maybe something like this in D4 copied over to I4
=IF(AND(D2="x",D3=""),"Input Needed","")
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
this works great.....thanks for your help....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks