formula is too long

Hello

Can any one please help me in this,how can in compress the following formula

=IF(B3="Monthly",IF(B25="Windows 2003 Std",15,IF(B25="Windows 2003 Ent",30,IF(B25="Windows 2008 Data Center ",40,IF(B25="RHEL 5","30",IF(B25="Windows 2008 Web","15",0))))))+(IF(B3="Quarterly",IF(B25="Windows 2003 Std",40,IF(B25="Windows 2003 Ent",75,IF(B25="RHEL 5","89",IF(B25="Windows 2008 Data Center ",120,IF(B25="Windows 2008 Web","45",0))))))+(IF(B3="Semi-Annually",IF(B25="Windows 2003 Std",75,IF(B25="Windows 2003 Ent",140,IF(B25="Windows 2008 Data Center ",200,IF(B25="RHEL 5","149",IF(B25="Windows 2008 Web","90",0)))))))+(IF(B3="Annually",IF(B25="Windows 2003 Std",150,IF(B25="Windows 2003 Ent",300,IF(B25="RHEL 5","299",IF(B25="Windows 2008 Data Center ",400,IF(B25="Windows 2008 Web","180",0))))))))

Thanks
Rahul

Something like this:

First set up table on the side that lists the possibilities for B5 and tabulate the corresponding numbers in the next 4 columns.

Then assuming you put this table in V1:Z100 use formula

Please Login or Register  to view this content.

adjust the ranges to suit your data

I attached an approach that I would recommend.
It involves setting up this lookup table in F1:J6

Please Login or Register  to view this content.

Then using this formula

Please Login or Register  to view this content.

Does that help?

I attached an edited version of your workbook that demonstates the
proper lookup table structure and formulas for the Configuration section.

Lookup table:

Please Login or Register  to view this content.

Formula for

Please Login or Register  to view this content.

You'll need to create similar tables and formulas for each of the other sections.

I hope that helps.