Prev: formula to a minimum value of zero if a negative number
Next: vlookup function returning "na" even though the vlaues are present
From: Stuck! on 20 Mar 2010 01:21
I am trying to enter in a function in Excel that if is if A5 is less than
half of D5, if true Y if false N. I can not figure out how to enter the half
of D5 in
From: trip_to_tokyo on 20 Mar 2010 02:06
EXCEL 2007

Try this:

=IF(A5<(D5/2),"Y","N")

If my comments have helped please hit Yes.

Thanks.



"Stuck!" wrote:

> I am trying to enter in a function in Excel that if is if A5 is less than
> half of D5, if true Y if false N. I can not figure out how to enter the half
> of D5 in
From: Fred Smith on 20 Mar 2010 05:26
Half of D5 is =D5/2, so you want:
=if(a5<d5/2,"Y","N")

Regards,
Fred

"Stuck!" <Stuck!@discussions.microsoft.com> wrote in message
news:FE3A3C7A-C651-4825-96AE-C566167B9A6C(a)microsoft.com...
>I am trying to enter in a function in Excel that if is if A5 is less than
> half of D5, if true Y if false N. I can not figure out how to enter the
> half
> of D5 in

 | 
Pages: 1
Prev: formula to a minimum value of zero if a negative number
Next: vlookup function returning "na" even though the vlaues are present