View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Excel Logical IF function

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