Prev: Adding dates in columns
Next: how to key in a1 information on e1 wil appear at b1
From: Brian on 11 Apr 2010 19:56
Does anyone know how to create a cell that will calculate whether the number
in the orginal cell is above or below 40. If above 40 it will calculate at
$69.00 for anything over if below it will calculate at $46.00.

Thanks in advance
From: T. Valko on 11 Apr 2010 21:15
You account for anything less than 40 and anything greater than 40 but what
if the value IS 40?

I'll assume you want:

Less than or equal to 40 = 46
Greater than 40 = 69

=IF(COUNT(A1),IF(A1>40,69,46),"")

--
Biff
Microsoft Excel MVP


"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:47E9A381-EC4D-490B-AFC6-B8CD161D2DF4(a)microsoft.com...
> Does anyone know how to create a cell that will calculate whether the
> number
> in the orginal cell is above or below 40. If above 40 it will calculate at
> $69.00 for anything over if below it will calculate at $46.00.
>
> Thanks in advance


From: Max on 11 Apr 2010 21:18
Something like this, I reckon:
In B2, copied down: =IF(A2="","",IF(A2>40,A2*64,A2*46))
Adapt to suit. Any good? hit the YES below
--
Max
Singapore
---
"Brian" wrote:
> Does anyone know how to create a cell that will calculate whether the number
> in the orginal cell is above or below 40. If above 40 it will calculate at
> $69.00 for anything over if below it will calculate at $46.00
From: ozgrid.com on 11 Apr 2010 22:21
=IF(AND(NOT(ISBLANK(A1)),A1<40),46,IF(AND(A1>40,NOT(ISTEXT(A1))),69,0))

Format the result cell as Currency.

--
Regards
Dave Hawley
www.ozgrid.com
"Brian" <Brian(a)discussions.microsoft.com> wrote in message
news:47E9A381-EC4D-490B-AFC6-B8CD161D2DF4(a)microsoft.com...
> Does anyone know how to create a cell that will calculate whether the
> number
> in the orginal cell is above or below 40. If above 40 it will calculate at
> $69.00 for anything over if below it will calculate at $46.00.
>
> Thanks in advance

From: Khoshravan on 12 Apr 2010 01:42
Dear Valko

Hi.
What is the function of COUNT(A1) in
=IF(COUNT(A1),IF(A1>40,69,46),"")

According to your explanation, it accounts for entries equal to 40, but I
can not figure out "count" functionality in this regard.
Your note is highly appreciated.

--
Rasoul Khoshravan Azar



"T. Valko" wrote:

> You account for anything less than 40 and anything greater than 40 but what
> if the value IS 40?
>
> I'll assume you want:
>
> Less than or equal to 40 = 46
> Greater than 40 = 69
>
> =IF(COUNT(A1),IF(A1>40,69,46),"")
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "Brian" <Brian(a)discussions.microsoft.com> wrote in message
> news:47E9A381-EC4D-490B-AFC6-B8CD161D2DF4(a)microsoft.com...
> > Does anyone know how to create a cell that will calculate whether the
> > number
> > in the orginal cell is above or below 40. If above 40 it will calculate at
> > $69.00 for anything over if below it will calculate at $46.00.
> >
> > Thanks in advance
>
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Adding dates in columns
Next: how to key in a1 information on e1 wil appear at b1