Two TRUE to one FALSE statement
not sure what you mean by %(d2)<1 but
=if(or(c2b2,d2<.01),"late",if(c2<b2,"early","on time"))
adjust the d2 reference as needed
"bluebird" wrote:
Would like to create a formula that can return one of two true outcomes vs.
one false. For example:
if date2 (c2) < date1 (b2), then "early",
if date2 (c2) = date1 (b2), then "on time",
if date2 (c2) date2 (b2), or if %(d2)<1, then "late".
Can this be done? Any help greatly appreciated!
|