Search : in
By :

IF Function in excell

Last answer on Nov 23, 2009 2:02:37 am GMT Hil, on Nov 4, 2009 12:24:02 am GMT 
 Report this message to moderators

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

Configuration: Windows Vista Internet Explorer 8.0

Best answers for « IF Function in excell » in :
[Excel 2003] - IF Function using Dates & Text Show [Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[VBA] Detecting changes in cell Show[VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
The Fn key is locked ShowThe Fn key is locked If you're writing numbers instead of letters when you press the keyboard of your laptop and you must hold down the Function key (Fn) to write normally. This is due to the fact that the digital lock is activated. To...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Spreadsheets - Logic Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Spreadsheet - Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...

1

xpcman, on Nov 4, 2009 1:54:35 am GMT

I suggest you do your school assignment yourself.

Good Luck

Reply to xpcman

2

 chaok28, on Nov 23, 2009 2:02:37 am GMT

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

Reply to chaok28