“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

use the IF function in Net Price cell. There is a discount of 2% applied to the Unit Price in E15 if 2 or more items are ordered and a discount applied if 10 or more are ordered. Refer to the appropriate discounts in cells e10, e11, and e12 for your if function arguments. Use absolute and relative references when appropriate.................I am having trouble with the if piece between 2 and 10...Can you help?

Solved by X. S. in 17 mins

im working on some data but the excel absolute value of time isnt showing. Its showing another number which i cant figure out

Solved by C. D. in 15 mins

In the Comp Days column, enter a formula with nested IFs to display the number of comp days that an employee will receive based on their years of service. The table for Comp Days is on the Data Tables worksheet. Use absolute value functions to the cells in the Data Tables worksheet because the formula will be copied to the entire column

Solved by I. J. in 25 mins

Tab "3"Problem #5 (B39)
On the column N, please show any number's absolute value that is greater than $5000. Please help how to do absolute value in excel!

Solved by D. U. in 18 mins

In cell C5, insert the appropriate lookup function (VLOOKUP or HLOOKUP) that uses the membership type to match up in the lookup table and to ultimately display the basic annual membership cost for the first client.
For this function, provide the argument for range_lookup (either TRUE or FALSE).
As this function will be copied to other cells, determine whether each excel absolute cell reference

Solved by E. J. in 15 mins

In cell H5, insert the appropriate lookup function (VLOOKUP or HLOOKUP) to display the amount of down payment required based on the membership type.
For this function, provide the argument for range_lookup (either TRUE or FALSE).
As this function will be copied to other cells, determine whether each cell reference should be relative or absolute.
Copy the function to the remaining cells in the column (through row 13).

Solved by Z. B. in 13 mins

In cell J5, insert a function (PMT) to calculate the first client’s monthly payment.
Remember to convert the annual percentage rate into an appropriate periodic rate.
Think about how the nper (number of payments over the life of the loan) is calculated.
Change the sign of the result, inserting a minus sign before the function's name, in order to have the result display as a positive number instead of a negative number.
As this function will be copied to other cells, determine whether each cell reference should be absolute value of negative number.

Solved by X. B. in 15 mins

I need to absolute cell reference the formulas under the years.. "2017,2018,2019"

Solved by D. D. in 19 mins

The expenses will increase by the individual percentage figures shown in the worksheet, under the heading 'Expected increase in expenses'. Use abs excel referencing where possible

Solved by I. Q. in 22 mins

I need to do an absolute cell reference for a given table so I can copy the formulas. Could you show me absolute value functions examples?

Solved by V. A. in 11 mins