Hi!

Try this:

=IF(G4<3000,G4*INDEX(Factors!C2:D8,DA2,CY2),G4*IND EX(Factors!C10:D16,DA2,CY2))

Biff

"dexman" wrote in
message ...

Here is where you can get the actual file

http://www.stuffilike.us/files/configurator.xlt

Anyone that would like to help...

the tabs that I have started working with are the VOS WaveScan tab. The
factors in which to calc the payments are on the Factors Tab.

Thanks


--
dexman
------------------------------------------------------------------------
dexman's Profile:
http://www.excelforum.com/member.php...o&userid=31481
View this thread: http://www.excelforum.com/showthread...hreadid=515153