Prev: Excel 2010
Next: Can anyone provide me the fomula ?
From: Trainee on 6 Jun 2010 11:36
I'm in need of a formula in C1 that gives me the value of A1 divided into
60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
THANKS.
From: Mike H on 6 Jun 2010 11:46
Hi,

This also checks they aren't both empty

=IF(COUNT(A1:B1)=0,"",IF(B1<>0,B1/60,A1/60))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Trainee" wrote:

> I'm in need of a formula in C1 that gives me the value of A1 divided into
> 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
> THANKS.
From: Gord Dibben on 6 Jun 2010 12:02
=IF(B1="",A1/60,IF(B1>0,B1/60,"B1 is <=0"))


Gord Dibben MS Excel MVP

On Sun, 6 Jun 2010 08:36:31 -0700, Trainee
<Trainee(a)discussions.microsoft.com> wrote:

>I'm in need of a formula in C1 that gives me the value of A1 divided into
>60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
>THANKS.

From: Trainee on 6 Jun 2010 12:04

THANK YOU! good formula Mike H.

"Mike H" wrote:

> Hi,
>
> This also checks they aren't both empty
>
> =IF(COUNT(A1:B1)=0,"",IF(B1<>0,B1/60,A1/60))
> --
> Mike
>
> When competing hypotheses are otherwise equal, adopt the hypothesis that
> introduces the fewest assumptions while still sufficiently answering the
> question.
>
>
> "Trainee" wrote:
>
> > I'm in need of a formula in C1 that gives me the value of A1 divided into
> > 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
> > THANKS.
From: Mike H on 6 Jun 2010 12:10
your welcome
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Trainee" wrote:

>
> THANK YOU! good formula Mike H.
>
> "Mike H" wrote:
>
> > Hi,
> >
> > This also checks they aren't both empty
> >
> > =IF(COUNT(A1:B1)=0,"",IF(B1<>0,B1/60,A1/60))
> > --
> > Mike
> >
> > When competing hypotheses are otherwise equal, adopt the hypothesis that
> > introduces the fewest assumptions while still sufficiently answering the
> > question.
> >
> >
> > "Trainee" wrote:
> >
> > > I'm in need of a formula in C1 that gives me the value of A1 divided into
> > > 60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
> > > THANKS.
 | 
Pages: 1
Prev: Excel 2010
Next: Can anyone provide me the fomula ?