excel problem

allardbaseball

New Member
Joined
Nov 2, 2009
Messages
2
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
Joined
Dec 31, 2007
Messages
460
=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
Joined
Nov 2, 2009
Messages
2
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
Joined
Dec 31, 2007
Messages
460
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
 

Forum statistics

Threads
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?

Disable AdBlock

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
Top