Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula-simple question; simple operator
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula-simple question; simple operator
I am not sure you would call this simple, but try this formula in cell E1
=IF(AND(A1="JOB",OR(ISBLANK(B1),OR(ISBLANK(C1),ISB LANK(D1)))),"MISSING INFO","ALL DATA THERE") "Rich D" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula-simple question; simple operator
In E1 enter:
=IF(OR(ISBLANK(B1),ISBLANK(C1),ISBLANK(D1)),"MISSI NG INFO","") "Rich D" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula-simple question; simple operator
Try this in E1
=IF(A1="job",IF(COUNTA(B1:D1)<3,"Missing date",""),"This appears if Job isn't in A1") You don't specify what to do if A1 doesn't contain Job so this formula displays This appears if Job isn't in A1 You could simply leave emprt quotes and display nothing if you prefer. Mike "Rich D" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple Formula Question | Excel Discussion (Misc queries) | |||
Very simple, but difficult formula question | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |