custom add formula

[Kelly********]

How do I make the last formula times by 1.5 then add all formulas togethe
=IF((VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F6>0,(VLOOKUP(D6,PNTVAL,2,FALSE))+E6+F6,""
=IF((VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K6>0,(VLOOKUP(I6,PNTVAL,2,FALSE))+J6+K6,""
=IF((VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P6>0,(VLOOKUP(N6,PNTVAL,2,FALSE))+O6+P6,""
=IF((VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U6>0,(VLOOKUP(S6,PNTVAL,2,FALSE))+T6+U6,""
=IF((VLOOKUP(X6,PNTVAL,2,FALSE))+Y6+Z6>0,(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+AE6>0,(VLOOKUP(AC6,PNTVAL,2,FALSE))+AD6+AE6,"")
My next calculation is
=IF(AH5>0,SUM(G5,L5,Q5,V5,AA5,AF5,AH5),IF(AH5<0,SUM(G5,L5,Q5,V5,AA5,AF5)))
Then
=IF(AI5>0,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

 

[T. Valko]

You already have 1.5 entered in cell AF2 so:

=IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5)*AF$2,"")

Copied down

 

[Kelly********]

but I dont want it to times BY 1.5 AC5,AD5,ADE just AF5

 

[T. Valko]

In other words, you want just the lookup result to be multiplied?

=IF(VLOOKUP(AC5,PNTVAL,2,0)+AD5+AE5,(VLOOKUP(AC5,PNTVAL,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.

 

[Kelly********]

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]

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.

 

[Kelly********]

OK thanks for your help works good

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.

 

[T. Valko]

You're welcome. Thanks for the feedback!