| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
custom add formula
How do I make the last formula times by 1.5 then add all formulas together
=IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F60,(VLOOKUP( D6,PNTVAL,2,FALSE))+E6+F6,"") =IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K60,(VLOOKUP( I6,PNTVAL,2,FALSE))+J6+K6,"") =IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P60,(VLOOKUP( N6,PNTVAL,2,FALSE))+O6+P6,"") =IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U60,(VLOOKUP( S6,PNTVAL,2,FALSE))+T6+U6,"") =IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z60,(VLOOKUP( X6,PNTVAL,2,FALSE))+Y6+Z6,"") This is where I need it to times AF6 by 1.5 I would like to be able to change that to what ever number i want. =IF((VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE60,(VLOOK UP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"") My next calculation is =IF(AH50,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SU M(G5,L5,Q5,V5,AA5,AF5))) Then =IF(AI50,RANK(AI5,$AI$4:$AI$72),"") If it would be eisier to see what Im trying to do go here http://www.wichitarcraceway.com/excel.htm and download |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom add formula
You already have 1.5 entered in cell AF2 so:
=IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)+AD5+AE5)*AF$2,"") Copied down -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... How do I make the last formula times by 1.5 then add all formulas together =IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F60,(VLOOKUP( D6,PNTVAL,2,FALSE))+E6+F6,"") =IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K60,(VLOOKUP( I6,PNTVAL,2,FALSE))+J6+K6,"") =IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P60,(VLOOKUP( N6,PNTVAL,2,FALSE))+O6+P6,"") =IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U60,(VLOOKUP( S6,PNTVAL,2,FALSE))+T6+U6,"") =IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z60,(VLOOKUP( X6,PNTVAL,2,FALSE))+Y6+Z6,"") This is where I need it to times AF6 by 1.5 I would like to be able to change that to what ever number i want. =IF((VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE60,(VLOOK UP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"") My next calculation is =IF(AH50,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SU M(G5,L5,Q5,V5,AA5,AF5))) Then =IF(AI50,RANK(AI5,$AI$4:$AI$72),"") If it would be eisier to see what Im trying to do go here http://www.wichitarcraceway.com/excel.htm and download |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom add formula
but I dont want it to times BY 1.5 AC5,AD5,ADE just AF5
"T. Valko" wrote: You already have 1.5 entered in cell AF2 so: =IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)+AD5+AE5)*AF$2,"") Copied down -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... How do I make the last formula times by 1.5 then add all formulas together =IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F60,(VLOOKUP( D6,PNTVAL,2,FALSE))+E6+F6,"") =IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K60,(VLOOKUP( I6,PNTVAL,2,FALSE))+J6+K6,"") =IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P60,(VLOOKUP( N6,PNTVAL,2,FALSE))+O6+P6,"") =IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U60,(VLOOKUP( S6,PNTVAL,2,FALSE))+T6+U6,"") =IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z60,(VLOOKUP( X6,PNTVAL,2,FALSE))+Y6+Z6,"") This is where I need it to times AF6 by 1.5 I would like to be able to change that to what ever number i want. =IF((VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE60,(VLOOK UP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"") My next calculation is =IF(AH50,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SU M(G5,L5,Q5,V5,AA5,AF5))) Then =IF(AI50,RANK(AI5,$AI$4:$AI$72),"") If it would be eisier to see what Im trying to do go here http://www.wichitarcraceway.com/excel.htm and download |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom add formula
In other words, you want just the lookup result to be multiplied?
=IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)*AF$2)+AD5+AE5,"") You can even shorten that to: =(VLOOKUP(AC5,PNTVAL,2,0)*AF$2)+AD5+AE5 Since the result of the lookup is either 0 or 0 and you already have 0 display turned off, there's really no reason to use the IF and return a blank. -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... but I dont want it to times BY 1.5 AC5,AD5,ADE just AF5 "T. Valko" wrote: You already have 1.5 entered in cell AF2 so: =IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)+AD5+AE5)*AF$2,"") Copied down -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... How do I make the last formula times by 1.5 then add all formulas together =IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F60,(VLOOKUP( D6,PNTVAL,2,FALSE))+E6+F6,"") =IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K60,(VLOOKUP( I6,PNTVAL,2,FALSE))+J6+K6,"") =IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P60,(VLOOKUP( N6,PNTVAL,2,FALSE))+O6+P6,"") =IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U60,(VLOOKUP( S6,PNTVAL,2,FALSE))+T6+U6,"") =IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z60,(VLOOKUP( X6,PNTVAL,2,FALSE))+Y6+Z6,"") This is where I need it to times AF6 by 1.5 I would like to be able to change that to what ever number i want. =IF((VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE60,(VLOOK UP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"") My next calculation is =IF(AH50,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SU M(G5,L5,Q5,V5,AA5,AF5))) Then =IF(AI50,RANK(AI5,$AI$4:$AI$72),"") If it would be eisier to see what Im trying to do go here http://www.wichitarcraceway.com/excel.htm and download |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom add formula
OK I think thats what I what it to do "great job" I spent hours and couldnt
get it thank you. If I can ask you one more question I dont know if you see the spead sheet but is there a way I could sort each section endivigualy by name and then if needed by rank. "T. Valko" wrote: In other words, you want just the lookup result to be multiplied? =IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)*AF$2)+AD5+AE5,"") You can even shorten that to: =(VLOOKUP(AC5,PNTVAL,2,0)*AF$2)+AD5+AE5 Since the result of the lookup is either 0 or 0 and you already have 0 display turned off, there's really no reason to use the IF and return a blank. -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... but I dont want it to times BY 1.5 AC5,AD5,ADE just AF5 "T. Valko" wrote: You already have 1.5 entered in cell AF2 so: =IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)+AD5+AE5)*AF$2,"") Copied down -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... How do I make the last formula times by 1.5 then add all formulas together =IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F60,(VLOOKUP( D6,PNTVAL,2,FALSE))+E6+F6,"") =IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K60,(VLOOKUP( I6,PNTVAL,2,FALSE))+J6+K6,"") =IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P60,(VLOOKUP( N6,PNTVAL,2,FALSE))+O6+P6,"") =IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U60,(VLOOKUP( S6,PNTVAL,2,FALSE))+T6+U6,"") =IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z60,(VLOOKUP( X6,PNTVAL,2,FALSE))+Y6+Z6,"") This is where I need it to times AF6 by 1.5 I would like to be able to change that to what ever number i want. =IF((VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE60,(VLOOK UP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"") My next calculation is =IF(AH50,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SU M(G5,L5,Q5,V5,AA5,AF5))) Then =IF(AI50,RANK(AI5,$AI$4:$AI$72),"") If it would be eisier to see what Im trying to do go here http://www.wichitarcraceway.com/excel.htm and download |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
custom add formula
Just select the section you want sorted and use column B as the "sort by"
key and the rank column as the "then by" key. -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... OK I think thats what I what it to do "great job" I spent hours and couldnt get it thank you. If I can ask you one more question I dont know if you see the spead sheet but is there a way I could sort each section endivigualy by name and then if needed by rank. "T. Valko" wrote: In other words, you want just the lookup result to be multiplied? =IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)*AF$2)+AD5+AE5,"") You can even shorten that to: =(VLOOKUP(AC5,PNTVAL,2,0)*AF$2)+AD5+AE5 Since the result of the lookup is either 0 or 0 and you already have 0 display turned off, there's really no reason to use the IF and return a blank. -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... but I dont want it to times BY 1.5 AC5,AD5,ADE just AF5 "T. Valko" wrote: You already have 1.5 entered in cell AF2 so: =IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,P NTVAL,2,0)+AD5+AE5)*AF$2,"") Copied down -- Biff Microsoft Excel MVP "Kelly********" wrote in message ... How do I make the last formula times by 1.5 then add all formulas together =IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F60,(VLOOKUP( D6,PNTVAL,2,FALSE))+E6+F6,"") =IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K60,(VLOOKUP( I6,PNTVAL,2,FALSE))+J6+K6,"") =IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P60,(VLOOKUP( N6,PNTVAL,2,FALSE))+O6+P6,"") =IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U60,(VLOOKUP( S6,PNTVAL,2,FALSE))+T6+U6,"") =IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z60,(VLOOKUP( X6,PNTVAL,2,FALSE))+Y6+Z6,"") This is where I need it to times AF6 by 1.5 I would like to be able to change that to what ever number i want. =IF((VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE60,(VLOOK UP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"") My next calculation is =IF(AH50,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SU M(G5,L5,Q5,V5,AA5,AF5))) Then =IF(AI50,RANK(AI5,$AI$4:$AI$72),"") If it would be eisier to see what Im trying to do go here http://www.wichitarcraceway.com/excel.htm and download |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use a formula in custom autofilter | Excel Worksheet Functions | |||
| Custom Header with Formula | Excel Discussion (Misc queries) | |||
| Need Custom format, not a formula | Excel Discussion (Misc queries) | |||
| How can I see custom formula code? | Excel Worksheet Functions | |||
| formula for custom output | Excel Discussion (Misc queries) | |||
Hybrid Mode
