equation formulas

Hello guys! Would just like some verification on why am I getting the wrong value/answer to this. Here's the problem: If d <= R then: tank = pi * d ^ 2 / 3 * (3 * R - d) but if d<=h - r then: tank = 2 / 3 * pi * R ^ 3 + pi * R ^ 2 * (d - H) Else: tank = 4 / 3 * pi * R ^ 3 + pi * R ^ 2 *...

Good Morning, I need help with an equation to finish my skills matrix. I want the calculate the hour rate of pay to increase for every skill greater than 1. Each skill has a total of 4 levels. Level 1 = Basic Level 2 = Performs with help Level 3 = Performs well Level 4 = Trainer So let say...

Problem: Cell A2 can be either "Categ 1" or "Categ 2". If Categ 1 is selected, a drop down list is provided in B1. Based on selection in B1's drop down list, its relative value is shown below in B2. If Categ 2 is selected in A2, then a completely different list is shown in B1, and based on that...

<tbody> A B C D E F G H I 1 Contract# Contract amount Already encumbered Invoices Paid Already Encumbered Balance Current Contract Amount Encumbered Unencumbered Balance 2 1234 100 50 40 40 10 </tbody> I made a small copy of my spreadsheet. I will try to explain what I want to do to...