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,857
I suggest you do your school assignment yourself.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!