Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dez
 
Posts: n/a
Default Alternative for IF function

I'm trying to use the IF function to get a value when the logic condition is
a variable "greater than" and "smaller than". Ex: IF (0<A1<=1,5;E1;B1). But a
come acrosse a problem. I have a lot of logic conditions and i have tryed to
put a IF function inside an IF function, ex:
IF(0<A1<=1,5;E1;IF(1,5<A1<=2;IF(...;..;...).
But, unfortunatly it dosen't worked. Is there any alternative?

Thanks
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Dez,

Try

IF (AND(0<A1;A1<=1,5);E1;B1).

--
HTH

Bob Phillips

"Dez" wrote in message
...
I'm trying to use the IF function to get a value when the logic condition

is
a variable "greater than" and "smaller than". Ex: IF (0<A1<=1,5;E1;B1).

But a
come acrosse a problem. I have a lot of logic conditions and i have tryed

to
put a IF function inside an IF function, ex:
IF(0<A1<=1,5;E1;IF(1,5<A1<=2;IF(...;..;...).
But, unfortunatly it dosen't worked. Is there any alternative?

Thanks



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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date & Time mully New Users to Excel 4 May 23rd 05 12:56 PM
Excel If function alternative saborbas Excel Worksheet Functions 6 April 24th 05 01:18 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 03:29 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 11:49 AM
Find a Function to use accross different worksheets R. Hale Excel Worksheet Functions 3 November 25th 04 08:07 AM


All times are GMT +1. The time now is 11:34 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"