Formula question

[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))

 

[Frank Kabel]

Hi
no njeed for the '+' in this formula. delete it

 

[Earl Kiosterud]

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.

 

[Frank Kabel]

Hi
the '+' has no function in this formula