IF Function in excell Closed

Question

Hello
 The cost of insurance is based on the value of the artwork. If 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 in G6 to compute the cost of insurance and copy the formula to the remaining cells in the column
Value = F6 258
            F7 1000
            F8 2058
            F9 597
            F10 358
            F11 2594
            F12 1284
            F13 1578
            F14 128
            F15 2458
            F16 254
            F17 564
            F18 812
            F19 1255

xpcman · Answer

I suggest you do your school assignment yourself.

Good Luck

chaok28 · Answer

could you please give that 
 to calculate insurance using if function in excell please?

IF Function in excell

2 responses

Similar discussions

Subscribe To Our Newsletter!