No return for formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using formula - =if($f5>"0",f5-e5,"") returns no response.

trying to get the difference b etwwen 2 dates where "F" column is day
vehicle left and "E" column is day vehicle arrived.

Is my formula wrong?
 
Hi

I think you need
=IF($F5>0,F5-E5,"")
Format the cell as General.
From your description, I'm not sure which is the later date.
As long a column F is later than column E, then it will be fine. Otherwise
you will need to reverse the calculation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top