Previous Thread

7/11/2006 4:18:02 PM    Creating multiple IF lines - complicated problem -
Hi, 
 
I've used excel in its simplist form for a while now, however just 
 
recently I've attempted to make something clearly beyond my skill level 
 
Ive displayed below a flowsheet of what Im trying to achieve 
 
'[image: http://images6.theimagehosting.com/Excelsheet.JPG]' 
 
(http://www.theimagehosting.com) 
 
Currently the below is what I've done, This takes into account only the 
 
first instruction excluding the part where it verifies if the sum = a 
 
specific amount and if its less, it replaces with the original amount 
 
=IF(F17<L11,F17*K11, "=IF(AND(f17>751,f17<100),f17*.32") 
 
I would welcome any help, and would be extremely thankful. 
 
O, all of this I am hoping to be able to have calculated in one cell if 
 
possibly. 
 
Regards 
 
Ryan 
 
-- 
 
lokideviluk 
 
------------------------------------------------------------------------ 
 
lokideviluk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36249 
 
View this thread: http://www.excelforum.com/showthread.php?threadid=560445



7/11/2006 5:52:30 PM    Re: Creating multiple IF lines - complicated problem -
I would suggest that you create a small table somewhere which contains 
 
your cut-offs, factors and comparison values, as follows: 
 
0     0.36     217.80 
 
751     0.32     275.20 
 
1001     0.30     332.65 
 
and so on for your seven conditions. I'm not sure if your first value 
 
should be 100, as this is shown in your formula. Suppose this table is 
 
located from X1 to Z7 on the same sheet. I imagine that F17 contains 
 
the number to be acted upon, so try this formula: 
 
=MAX(F17*VLOOKUP(F17,X$1:Z$7,2,1),VLOOKUP(F17,X$1:Z$7,3,1)) 
 
If the first value in your table is 100, you don't specify what you 
 
want to do if F17 is less than this. 
 
The formula can be copied down if you have other values in column F. 
 
Hope this helps. 
 
Pete 
 
lokideviluk wrote: