# excel problem

#### allardbaseball

##### New Member
if the value is greater than \$500, then the insurance is 25% of the value, if less than then its 10%--the dollar amounts are in a column f6--for an excel class

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### General Ledger

##### Active Member
=If (F6>500,0.25*F6,0.1*F6)
This formula reads like: If F6 is greater than 500, then multiply .25 times F6, else multiply .1 times F6)
Not sure what you want to have happen if F6=500.

#### allardbaseball

##### New Member
Thanks that was it, I'm 43 and new to excel, I actually have another problem it ask for the cube footage is calculated by multiply wwith * Height and / by 144

#### General Ledger

##### Active Member
To calculate volume of a rectangle = Width * Height * Length

If measurements are given in inches but you want the result in feet
= (Width/12) * (Height/12) * (Length/12) or more simply
= (Width * Height * Length)/1728
where 1728 = 12 * 12 * 12

To calculate area of a rectangle = Width * Length

If measurements are given in inches but you want the result in feet
= (Width/12) * (Length/12) or more simply
= (Width * Length)/144
where 144 = 12 * 12

Replies
3
Views
50
Replies
9
Views
485
Replies
5
Views
102
Replies
5
Views
64
Replies
0
Views
87

1,136,644
Messages
5,676,967
Members
419,665
Latest member
allsmilees2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back