...Formulas used in Excel must follow a certain syntax. All formulas begin with an equals sign (=). Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division. For ...
Excel Formula I have been using excel for a number of years and make good use of the formulae. However, today when I enter a simple formula e.g. =F112+G112, I am not getting any result. The formula as
Question about Microsoft Excel Computers & Internet
I"m trying to show paying off a credit card and when the balance turns negative, the formula shows 0. I can'tseem t oget the if formula right to show 0 my bsic formula works=(((last year's blaance ...
formaul I have the following formula on sheet 37, =sum('game 1'!c5). I want to use the formula in the following manner. I have 36 sheets each sheet is named game 1 thru game 36. I want to take the ...
Question about Microsoft Excel Computers & Internet
...to avoid entering it 24 different times. i know that the answer lies in absolute and relative formulas but i am confused as to when and where to use the $ sign in the formula. If the column is ...
FORMULA NEEDED FAST Project I am working on has the following: Base Rate, Opt Yr 1, Opt Yr 2, Opt Yr 3, Opt Yr 4. I need each Opt Yr to calculate Base Rate + 5%, However, I have 40 rows to do this for
Help with simple excel calculations im sure this is simple for you but it has been driving me crazy. I need the value in a1 to equal b1 then when i put a value in a2 i want the sum in b2 and so forth.
Question about Microsoft Excel Computers & Internet
Excel will not displaying the results of a trend array formula I have column A showing months 1 to 12, and column B is 12 values. In column C I have the formula "{=TREND(C3:C14,A3:A14)}". I have use ...
Question about Microsoft Excel Computers & Internet
...I prevent this? There are 2 types of direct cell references that you can use when you're writing formulas: Relative References & Absolute References. A Relative Reference is the address of a ...
54 questions posted
Usually answered in minutes!
592 Questions
22 Questions
12 Questions
2 Questions