IF function + a formula
Is your system clock set correctly?
--
Rick (MVP - Excel)
"Per Jessen" wrote in message
...
Hi
The formula in the cell where you need the result could look like this:
=if(A2="Home",+((C2-Criteria)-M2)/60,0)
Regards,
Per
"Cindyt" skrev i meddelelsen
...
I am trying to figure out how I can use the IF function to identify a
word,
such as "Home". If it is true, I need to do a formula on that line of
information. The formula I am using is =+((C2-Criteria)-M2)/60. I
cannot
seem to add all this together and make it work. I am using Excel 2003.
thanks!
|