»
S
I
D
E
B
A
R
«
Excel Formula Dollar Sign
September 28th, 2006 by admin

excel formula dollar sign
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??

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


Leave a Reply

»  Substance: WordPress   »  Style: Ahren Ahimsa