View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
QA Queen QA Queen is offline
external usenet poster
 
Posts: 1
Default I need help with a formula.

I've subtracted two dates and now I want to do a IF statement. Do I have to
convert to numeric to do that? It's not bringing up correct values. At this
time H7 equals :45. How do I get the formula to work?

=IF(H7<=35,"On Target","Not on Target")