excel formula
in [Functions]
|
From: Khoshravan on 12 Apr 2010 01:58 Back to my previous post, I think I got the answer. "count" checks to see if the cell is empty or not and leaves the result empty if origin is empty or not-number and enters second "if" otherwise. That count usage was nice, but I couldn't understand its relation to equal part to 40. -- 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 > > > . >
From: T. Valko on 12 Apr 2010 21:36 Yes, you pretty much got it figured out. COUNT tests that there is in fact only a number entered in the cell. Without testing for a number it would be possible that if the cell contained a TEXT entry then: A1>40 would be TRUE and give an incorrect (or unexpected) result. -- Biff Microsoft Excel MVP "Khoshravan" <khoshravan(a)discussions.microsoft.com> wrote in message news:F5D461AE-9F97-4249-B134-BB7F7E409371(a)microsoft.com... > Back to my previous post, I think I got the answer. "count" checks to see > if > the cell is empty or not and leaves the result empty if origin is empty or > not-number and enters second "if" otherwise. > > That count usage was nice, but I couldn't understand its relation to equal > part to 40. > -- > 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 >> >> >> . >>
First
|
Prev
|
Pages: 1 2 Prev: Adding dates in columns Next: how to key in a1 information on e1 wil appear at b1 |