View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default help with formula

"Richard" ha scritto nel messaggio
...
If B16 (which is a date) is between January 1st. and June 30th. then 3
If B16 (which is a date) is between July 1st. and September 30th then 2
If B16 (which is a date) is between October 1st. and December 31st. then 0
If B16 5 years then 4
Thanks in advance for any help!!


I don't understand the last if. What do you mean with

If B16 5 years then 4 ?




--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy