Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Computer Support (http://www.velocityreviews.com/forums/f33-computer-support.html)
-   -   Excel Spreadsheet Formula (http://www.velocityreviews.com/forums/t461751-excel-spreadsheet-formula.html)

BIGEYE 11-14-2005 07:45 PM

Excel Spreadsheet Formula
 
Just started using Excel 2003, used to use Lotus. Can anyone tell me how to
input a formula for this.
Three cells C1, D1, E1, each cell has a value.
Three other cells K1, L1, M1, each with values.
Another cell to test the condition as follows:
If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If any of the
conditions are false, put NO into the last cell.
Appreciate any help.
TIA



Blinky the Shark 11-14-2005 08:15 PM

Re: Excel Spreadsheet Formula
 
BIGEYE wrote:

> Just started using Excel 2003, used to use Lotus. Can anyone
> tell me how to input a formula for this.
> Three cells C1, D1, E1, each cell has a value.
> Three other cells K1, L1, M1, each with values.
> Another cell to test the condition as follows:
> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If any
> of the conditions are false, put NO into the last cell.
> Appreciate any help.
> TIA


=IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")

--
Blinky
Killing all Google Groups posts.
http://blinkynet.net/comp/uip5.html

Lord Gazwad of Grantham 11-14-2005 08:29 PM

Re: Excel Spreadsheet Formula
 
Blinky the Shark, <no.spam@box.invalid>, the congealed, sugar-coated fairy,
and dealer in salted cow manure, bellowed:

> BIGEYE wrote:
>
>> Just started using Excel 2003, used to use Lotus. Can anyone
>> tell me how to input a formula for this.
>> Three cells C1, D1, E1, each cell has a value.
>> Three other cells K1, L1, M1, each with values.
>> Another cell to test the condition as follows:
>> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If any
>> of the conditions are false, put NO into the last cell.
>> Appreciate any help.
>> TIA

>
> =IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")


BWAHAHAHAHAHAHAHA

--
For my own part, I have never had a thought which I could not set down
in words with even more distinctness than that with which I conceived
it. There is, however, a class of fancies of exquisite delicacy which
are not thoughts, and to which as yet I have found it absolutely
impossible to adapt to language. These fancies arise in the soul, alas
how rarely. Only at epochs of most intense tranquillity, when the
bodily and mental health are in perfection. And at those weird points
of time, where the confines of the waking world blend with the world of
dreams. And so I captured this fancy, where all that we see, or seem,
is but a dream within a dream.






why? 11-14-2005 08:45 PM

Re: Excel Spreadsheet Formula
 

On Mon, 14 Nov 2005 19:45:15 -0000, "BIGEYE" <address@is[invalid].ok>
wrote:

>Just started using Excel 2003, used to use Lotus. Can anyone tell me how to
>input a formula for this.
>Three cells C1, D1, E1, each cell has a value.
>Three other cells K1, L1, M1, each with values.
>Another cell to test the condition as follows:
>If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If any of the
>conditions are false, put NO into the last cell.


IIRC same as Supercalc and Lotus , although it's been a while.

cell for the answer

=IF(test1,result1true,result1false)

expand this out to

=IF(test1,IF(test2,IF(test3,result3true,result3fal se),result2false),result1false)

You simply nest a further test, where you need it.

It works fine for up to 6 then it's tricky to keep things straight.


Run XL , press F1 , for Help.
IF_worksheet_function


Me

BIGEYE 11-14-2005 09:29 PM

Re: Excel Spreadsheet Formula
 
"Blinky the Shark" <no.spam@box.invalid> wrote in message
news:Xns970E7C97DBC93bnooz@130.133.1.4...
> BIGEYE wrote:
>
>> Just started using Excel 2003, used to use Lotus. Can anyone
>> tell me how to input a formula for this.
>> Three cells C1, D1, E1, each cell has a value.
>> Three other cells K1, L1, M1, each with values.
>> Another cell to test the condition as follows:
>> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If any
>> of the conditions are false, put NO into the last cell.
>> Appreciate any help.
>> TIA

>
> =IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")
>
> --
> Blinky
> Killing all Google Groups posts.
> http://blinkynet.net/comp/uip5.html



Thanks for that, now what if the expression was OR instead of AND.
If K1<C1 or L1<D1 or M1<E1, put YES into the last cell. If any of the
conditions are false, put NO into the last cell.
TIA



Blinky the Shark 11-14-2005 09:37 PM

Re: Excel Spreadsheet Formula
 
BIGEYE wrote:

> "Blinky the Shark" <no.spam@box.invalid> wrote in message
> news:Xns970E7C97DBC93bnooz@130.133.1.4...
>> BIGEYE wrote:
>>
>>> Just started using Excel 2003, used to use Lotus. Can anyone
>>> tell me how to input a formula for this.
>>> Three cells C1, D1, E1, each cell has a value.
>>> Three other cells K1, L1, M1, each with values.
>>> Another cell to test the condition as follows:
>>> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If
>>> any of the conditions are false, put NO into the last cell.
>>> Appreciate any help.
>>> TIA

>>
>> =IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")

>
> Thanks for that, now what if the expression was OR instead of
> AND. If K1<C1 or L1<D1 or M1<E1, put YES into the last cell. If
> any of the conditions are false, put NO into the last cell.
> TIA


Sorry, only the first joint is free. ;)

(Just kidding; but what I gave you is all the Excel I feel like
doing today. I'm an Open Office user (Linux) (I'm only here in
Windows on a backup computer while I'm rebuilding my Linux box),
and MS products give me hives. <g>)


--
Blinky
Killing all Google Groups posts.
http://blinkynet.net/comp/uip5.html

Blinky the Shark 11-14-2005 09:46 PM

Re: Excel Spreadsheet Formula
 
BIGEYE wrote:

> "Blinky the Shark" <no.spam@box.invalid> wrote in message
> news:Xns970E7C97DBC93bnooz@130.133.1.4...
>> BIGEYE wrote:
>>
>>> Just started using Excel 2003, used to use Lotus. Can anyone
>>> tell me how to input a formula for this.
>>> Three cells C1, D1, E1, each cell has a value.
>>> Three other cells K1, L1, M1, each with values.
>>> Another cell to test the condition as follows:
>>> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If
>>> any of the conditions are false, put NO into the last cell.
>>> Appreciate any help.
>>> TIA

>>
>> =IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")
>> --
>> Blinky

>
> Thanks for that, now what if the expression was OR instead of
> AND. If K1<C1 or L1<D1 or M1<E1, put YES into the last cell. If
> any of the conditions are false, put NO into the last cell.
> TIA


Second response: oh, what the heck... :)

=OR(K1<C1,L1<D1,M1<E1)

Actually, you could do the same for your first quesiton,
substituting "AND" for "OR". I didn't think about that until you
asked the "OR" question -- I'm so used to using IF statements that I
just automatically went that way for your first question.

Now -- start looking in Excel's function help when you need this
kinda stuff, eh? Thanks.


--
Blinky
Killing all Google Groups posts.
http://blinkynet.net/comp/uip5.html

Blinky the Shark 11-14-2005 09:48 PM

Re: Excel Spreadsheet Formula
 
why? wrote:

>
> On Mon, 14 Nov 2005 19:45:15 -0000, "BIGEYE"
> <address@is[invalid].ok> wrote:
>
>>Just started using Excel 2003, used to use Lotus. Can anyone
>>tell me how to input a formula for this.
>>Three cells C1, D1, E1, each cell has a value.
>>Three other cells K1, L1, M1, each with values.
>>Another cell to test the condition as follows:
>>If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If any
>>of the conditions are false, put NO into the last cell.

>
> IIRC same as Supercalc and Lotus , although it's been a while.
>
> cell for the answer
>
>=IF(test1,result1true,result1false)
>
> expand this out to
>
>=IF(test1,IF(test2,IF

(test3,result3true,result3false),result2false
>),result1false)


It's interesting that like me, you didn't suggest the AND
function, either. See my responses to OP -- I'm just used to
using IF statements, and didn't think about AND until he asked
about OR in a followup. :)

--
Blinky
Killing all Google Groups posts.
http://blinkynet.net/comp/uip5.html

BIGEYE 11-14-2005 10:04 PM

Re: Excel Spreadsheet Formula
 
"Blinky the Shark" <no.spam@box.invalid> wrote in message
news:Xns970E8BFF9E0D5bnooz@130.133.1.4...
> BIGEYE wrote:
>
>> "Blinky the Shark" <no.spam@box.invalid> wrote in message
>> news:Xns970E7C97DBC93bnooz@130.133.1.4...
>>> BIGEYE wrote:
>>>
>>>> Just started using Excel 2003, used to use Lotus. Can anyone
>>>> tell me how to input a formula for this.
>>>> Three cells C1, D1, E1, each cell has a value.
>>>> Three other cells K1, L1, M1, each with values.
>>>> Another cell to test the condition as follows:
>>>> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If
>>>> any of the conditions are false, put NO into the last cell.
>>>> Appreciate any help.
>>>> TIA
>>>
>>> =IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")
>>> --
>>> Blinky

>>
>> Thanks for that, now what if the expression was OR instead of
>> AND. If K1<C1 or L1<D1 or M1<E1, put YES into the last cell. If
>> any of the conditions are false, put NO into the last cell.
>> TIA

>
> Second response: oh, what the heck... :)
>
> =OR(K1<C1,L1<D1,M1<E1)
>
> Actually, you could do the same for your first quesiton,
> substituting "AND" for "OR". I didn't think about that until you
> asked the "OR" question -- I'm so used to using IF statements that I
> just automatically went that way for your first question.
>
> Now -- start looking in Excel's function help when you need this
> kinda stuff, eh? Thanks.
>
>
> --
> Blinky
> Killing all Google Groups posts.
> http://blinkynet.net/comp/uip5.html



Going back to the AND, it works OK when all conditions are true, YES gets
put in the formula cell. But if one of them becomes false, then FALSE gets
put in the cell instead of NO.
If I use AND as in your second suggestion, I end up with #value in the
formula cell.



Lord Gazwad of Grantham 11-14-2005 10:19 PM

Re: Excel Spreadsheet Formula
 
BIGEYE, <address@is[invalid].ok>, the oblique, wayward moldwarp, and
employee responsible for building high stone walls from small pebbles using
dog **** for mortar, buzzed:

> "Blinky the Shark" <no.spam@box.invalid> wrote in message
> news:Xns970E8BFF9E0D5bnooz@130.133.1.4...
>> BIGEYE wrote:
>>
>>> "Blinky the Shark" <no.spam@box.invalid> wrote in message
>>> news:Xns970E7C97DBC93bnooz@130.133.1.4...
>>>> BIGEYE wrote:
>>>>
>>>>> Just started using Excel 2003, used to use Lotus. Can anyone
>>>>> tell me how to input a formula for this.
>>>>> Three cells C1, D1, E1, each cell has a value.
>>>>> Three other cells K1, L1, M1, each with values.
>>>>> Another cell to test the condition as follows:
>>>>> If K1<C1 and L1<D1 and M1<E1, put YES into the last cell. If
>>>>> any of the conditions are false, put NO into the last cell.
>>>>> Appreciate any help.
>>>>> TIA
>>>>
>>>> =IF(K1<C1,IF(L1<D1,IF(M1<E1,"YES"),"NO"),"NO")
>>>> --
>>>> Blinky
>>>
>>> Thanks for that, now what if the expression was OR instead of
>>> AND. If K1<C1 or L1<D1 or M1<E1, put YES into the last cell. If
>>> any of the conditions are false, put NO into the last cell.
>>> TIA

>>
>> Second response: oh, what the heck... :)
>>
>> =OR(K1<C1,L1<D1,M1<E1)
>>
>> Actually, you could do the same for your first quesiton,
>> substituting "AND" for "OR". I didn't think about that until you
>> asked the "OR" question -- I'm so used to using IF statements that I
>> just automatically went that way for your first question.
>>
>> Now -- start looking in Excel's function help when you need this
>> kinda stuff, eh? Thanks.
>>
>>
>> --
>> Blinky
>> Killing all Google Groups posts.
>> http://blinkynet.net/comp/uip5.html

>
>
> Going back to the AND, it works OK when all conditions are true, YES
> gets put in the formula cell. But if one of them becomes false, then
> FALSE gets put in the cell instead of NO.
> If I use AND as in your second suggestion, I end up with #value in the
> formula cell.


What do you expect when you listen to a dumb **** like that, eh?

--
For my own part, I have never had a thought which I could not set down
in words with even more distinctness than that with which I conceived
it. There is, however, a class of fancies of exquisite delicacy which
are not thoughts, and to which as yet I have found it absolutely
impossible to adapt to language. These fancies arise in the soul, alas
how rarely. Only at epochs of most intense tranquillity, when the
bodily and mental health are in perfection. And at those weird points
of time, where the confines of the waking world blend with the world of
dreams. And so I captured this fancy, where all that we see, or seem,
is but a dream within a dream.







All times are GMT. The time now is 04:32 PM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.