#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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...
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"