Prev: formula with {}
Next: VBA Editor Menu Bar and Toolbar disappears
From: Norm on 19 May 2010 13:14
Have I missed something here?
=IF(E13>0,"early",E13<0,"late")

Cheers!!
From: Iriemon on 19 May 2010 13:27
=IF(E13>0,"Early",if(E13=0,"","late")



"Norm" wrote:

> Have I missed something here?
> =IF(E13>0,"early",E13<0,"late")
>
> Cheers!!
From: Norm on 19 May 2010 16:05
Thanks,
E13 is a time value.. if E13 has a value of 12:30 and early is before 12:00
and late is after 12:45 and 12:00 to 12:45 is On Time how would I formula
this?
Cheers!!

"Norm" wrote:

> Have I missed something here?
> =IF(E13>0,"early",E13<0,"late")
>
> Cheers!!
From: Ron Rosenfeld on 19 May 2010 21:47
On Wed, 19 May 2010 10:14:10 -0700, Norm <Norm(a)discussions.microsoft.com>
wrote:

>Have I missed something here?
>=IF(E13>0,"early",E13<0,"late")
>
>Cheers!!

=if(e13>0,"early",if(e13<0,"late","on time"))
--ron
From: bala_vb on 20 May 2010 08:22

Ron Rosenfeld;954840 Wrote:
> On Wed, 19 May 2010 10:14:10 -0700, Norm
> <Norm(a)discussions.microsoft.com>
> wrote:
> -
> >Have I missed something here?
> >=IF(E13>0,"early",E13<0,"late")
> >
> >Cheers!!-
>
> =if(e13>0,"early",if(e13<0,"late","on time"))
> --ron

=if(istext(e13),"Non Numeric
value",if(e13>0,"early",if(e13<0,"late","on time")))


all the best




--
bala_vb
 | 
Pages: 1
Prev: formula with {}
Next: VBA Editor Menu Bar and Toolbar disappears