Wednesday, February 2, 2011

yogi_Return A Value Based On Entries In Other Multiple Cells

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  


Return a value in column D based on entries in columns A, B, and C

If Column A contains a value, "Quoted", 
if Column A an B both contain a value, "Booked" 
If column A, B & C all contain a value, "Invoiced" 
If all 3 columns are blank, the cell should be left blank

formula in cell D2




these formulas should work in Excel as well by making 
adjustment for the Arrayformula
use CSE (Ctrl+Shift+Enter) instead of ArrayFormula wraparound