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