IF Function in excell

Closed
Report
-
 chaok28 -
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

2 replies

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,947
I suggest you do your school assignment yourself.

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