Previous Topic Next Topic

IF Function in excell

Closed
Hil - Nov 3, 2009 at 07:24 PM
 chaok28 - Nov 22, 2009 at 09:02 PM
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
Related:

2 responses

Answer 1 / 2
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,826
Nov 3, 2009 at 08:54 PM
I suggest you do your school assignment yourself.

Good Luck
0
Answer 2 / 2
chaok28
Nov 22, 2009 at 09:02 PM
could you please give that
to calculate insurance using if function in excell please?
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses