Formula question

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hi,

Can someone explain to me the function of the "+" in front
of F5 in the following formula?

=(+F5-$D$4)/(365/12)

NOTE:
- $D$4 is the cell containing the date (fixed).
- F5 cell contains this formula =D4+($C$43*(365/12))
 
Tony,


This is the worksheet functions group, and there aren't any functions
(SUM(), IF(), etc.) in your post, but here goes.

the + serves to add another byte or so to the size of the code. I don't
know of anything else it accomplishes. You could leave it out. Sounds like
something left over from another implementation, like Lotus 123 or
something.
 
Back
Top