"IF" Formulas

[zebra31]

I am creating a drop down menu and was wanting to add "IF" formulas to total up a base price with the addition on selected options from a menu. I was needing help in writing a formula to total these fields.

 

[JamesW]

Hi,

Welcome to the board.

Can you give us an example of what you currently have? I don't know what you want to sum, and what the criteria are.

 

[zebra31]

Base Option 1 Option 2

<TABLE style="WIDTH: 391pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=522><COLGROUP><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><COL style="WIDTH: 162pt; mso-width-source: userset; mso-width-alt: 7899" width=216><COL style="WIDTH: 158pt; mso-width-source: userset; mso-width-alt: 7716" width=211><TBODY><TR style="HEIGHT: 20.1pt; mso-height-source: userset" height=26><TD style="BORDER-BOTTOM: windowtext 0.5pt dashed; BORDER-LEFT: windowtext 0.5pt dashed; BACKGROUND-COLOR: transparent; WIDTH: 71pt; HEIGHT: 20.1pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dashed" class=xl65 height=26 width=95>12 days</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dashed; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 162pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dashed" class=xl65 width=216>Split Base add 40 hours + 1 Day</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt dashed; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 158pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt dashed" class=xl65 width=211>Filler Primer add $4000 + 2 days</TD></TR></TBODY></TABLE>


I am Wanting to add the options to the base as they are chosen. only wanting to add the number of days in options to the base number.

 

[JamesW]

Right, so.

You have the days (12) in cell A1 (for example), and you have a drop down box in C1 (for example). When you select anything in the dropdown box add the days that are at the end to the days in A1?

If so:

=TRIM(LEFT(A1,SEARCH(" day",A1,1)))+TRIM(MID(C1,SEARCH("+ ",C1,1)+1,SEARCH(" day",C1,1)-SEARCH("+ ",C1,1)))

Where A1 is your day value (12) and C1 is your dropdown box.