Please see attachment for a complete explanation of the formula I need help with. I would sincerely appreciate your help.
jdubwhite 0 Newbie Poster
This attachment is potentially unsafe to open. It may be an executable that is capable of making changes to your file system, or it may require specific software to open. Use caution and only open this attachment if you are comfortable working with msword files.
gregianos 0 Newbie Poster
Try This...
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>Greg Ashworth</Author>
<LastAuthor>Greg Ashworth</LastAuthor>
<Created>2007-12-10T10:11:17Z</Created>
<LastSaved>2007-12-10T10:17:02Z</LastSaved>
<Company>The Insurance Broker Ltd</Company>
<Version>11.9999</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>7170</WindowHeight>
<WindowWidth>9435</WindowWidth>
<WindowTopX>240</WindowTopX>
<WindowTopY>45</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s22">
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
</Borders>
<Font x:Family="Swiss" ss:Size="9"/>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="s25">
<Alignment ss:Horizontal="Right" ss:Vertical="Bottom"/>
<Borders>
<Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="2"/>
<Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="2"/>
</Borders>
<Font x:Family="Swiss" ss:Size="9"/>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
<Style ss:ID="s27">
<Font x:Family="Swiss" ss:Size="9"/>
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid"/>
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="3" ss:ExpandedRowCount="10" x:FullColumns="1"
x:FullRows="1">
<Column ss:Index="3" ss:Width="533.25"/>
<Row ss:Index="4" ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Sell price:</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=(R[6]C-R[3]C)/1.0855"><Data
ss:Type="Number">4606.1722708429297</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*Need formula to calculate this # for me.</Data></Cell>
</Row>
<Row ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">State tax:</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=R[-1]C*0.0625"><Data ss:Type="Number">287.88576692768311</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*State tax is calculated my multiplying the sell price by 6.25%. Need formula to calculate this # for me.</Data></Cell>
</Row>
<Row ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Inv. tax:</Data></Cell>
<Cell ss:StyleID="s25" ss:Formula="=R[-2]C*0.023"><Data ss:Type="Number">105.94196222938739</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*Inventory tax is calculated by multiplying the sell price times 2.3%. Need formula to calculate this # for me.</Data></Cell>
</Row>
<Row ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Plates:</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="Number">0</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*If the vehicle needs plates this # will have to be manually entered by me. Price for plates varies depending on type of vehicle. </Data></Cell>
</Row>
<Row ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Title:</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="String">$30.50</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*If 4B has an amount entered into it this box needs to automatically change to $28.00. If not it will always be $30.50.</Data></Cell>
</Row>
<Row ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Doc.fee:</Data></Cell>
<Cell ss:StyleID="s25"><Data ss:Type="String">$50.00</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*This fee is charged to every customer and will always be $50.00.</Data></Cell>
</Row>
<Row ss:Height="13.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Total:</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="Number">5000</Data></Cell>
<Cell ss:StyleID="s27"><Data ss:Type="String">*This box will be filled in by me. From the example above this is where I would put in $4000.</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Print>
<ValidPrinterInfo/>
<PaperSizeIndex>9</PaperSizeIndex>
<VerticalResolution>0</VerticalResolution>
</Print>
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>9</ActiveRow>
<ActiveCol>1</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook> Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.