Thread
:
IF formula-simple question; simple operator
View Single Post
#
3
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
IF formula-simple question; simple operator
=IF(AND(A7="job",COUNTBLANK(B7:D7)0),"More","")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Rich D" wrote in message
...
If the entry in A1 is "Job", and if any of the cells B1, C1, D1 are blank,
I
want to return (in cell E1) the message "MISSING INFO". I know it's
simple
but I'm missing something myself.
Thanks,
--
Rich D
Armstrong Custom Homes
Redmond
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett