excel problem

[allardbaseball]

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

 

[General Ledger]

=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]

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]

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