View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default IF and IF and IF

On Mon, 24 Sep 2012 16:37:58 +0000, Ramona88 wrote:

Hi Stan,

Sorry about the wrong quoting.

I tried your formula but it still doesn't work. It always gives back "3"
for everything under 2 years.
Instead of the "<2*365" we need to say "=365 and <2*365" but again not
sure how to do that.

Please can you give it another try for me?


Since you didn't quote anything from what you were responding to, I
have no idea what you're talking about.


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...