I need help with excel 2007!!!?

You cannot vote on your own post 0 "The cost of insurance is based on the value of the artwork. If the value is greater than $500, then the insurance is 25% of the value; otherwise, the insurance is 10% of the value of the painting. Enter an IF function into G6 to compute the cost of insurance and copy the formula to the remaining cells in the column." Ive used =IF(F6>500,F6*0.25,F6*0.1) and=IF(F6>500;F6*0,25;F6*0,1) and i keep getting "the formula you've typed contains an error" and i cannot figure out what that error is to correct it. Am i typing the wrong cell #? The value amount is in F6. Should there be dollar signs in my formula??

Written by Emily H in Software

Better Answer

Your first formula should work or copy this formula (it works)
G6 =IF(F6>500,F6*0.25,F6*0.1)

Written by Ixlxl