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

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

Half of D5 is =D5/2, so you want:
=if(a5<d5/2,"Y","N")

Regards,
Fred

"Stuck!" wrote in message
...
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