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...
Using excel if function with data validation Show
IF Function Show
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
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...
[Myth] aMSN allows you to know if someone has blocked you on WLM ShowaMSN allows you to know if someone has blocked you on Windows Live Messenger Myth Reality Explanations Myth aMSN software allows us to know who blocked us on Windows Live Messenger. Reality FALSE Explanations When it was launched,...
Download Excel Viewer Show
Download Envisioneer Express ShowIf you plan to construct a home, but you do not succeed in imagining final outcome, then this program will serve you and answer your wait. Envisioneer express is a free program of modelling in 3D, notably plans of home. It understands functions of...
Spreadsheets - Mathematical Functions ShowStandard Functions Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative ODD(value) Rounds a number up to the...
E-Procurement - Management of the purchasing function Showe-Procurement The term "e-Procurement" (for Electronic Procurement, sometimes written eprocurement) refers to the use of new technologies to automate and optimize the purchasing function of the company. The term refers to a B2B exchange, i.e. a...
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...
Ask your question Reply

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
Ask your question Reply
They need your help