If Cell has entry...

  • Thread starter Thread starter barch78
  • Start date Start date
B

barch78

I need a formula that will query another cell and if it has an entry, t
return a value in the original cell.
For example,
a date is entered in Cell F8, I want Cell F9 to return "Completed"
 
Hi
try in F9
=IF(F8<>"","Completed","")
and you may additional use 'Data - Validation' to only allow dates for
cell F8
 
One more question,
It I want the formula to look for a range and return a value, what does
that look like?
Ie:
If number in cell B8 is between 1-7, the formula returns "less than one
week". If Cell B8 is less than 0, "OVERDUE".
 
Hi
try
=IF(B8>0,"Overdue",IF(B8=0,"Current",IF(B8<=7,"less than one
week","more than one week")))
 
Back
Top