I with an Excell formula I cannot figure out.

  • Thread starter Thread starter tkav1980
  • Start date Start date
  • Tags Tags
    Figure Formula
Click For Summary
SUMMARY

The discussion centers on creating an Excel formula to calculate a value based on invoice totals and chemical totals. The user requires assistance with cell E2, which should apply a conditional formula: if the value in cell D2 is less than 4000, it multiplies by 1%; if 4000 or greater, it multiplies by 2%. The correct formula provided is =IF(D2<4000,D2*0.01,D2*0.02), which utilizes Excel's logical functions to achieve the desired outcome.

PREREQUISITES
  • Basic understanding of Excel formulas
  • Familiarity with the IF function in Excel
  • Knowledge of cell referencing in spreadsheets
  • Experience with conditional calculations
NEXT STEPS
  • Learn advanced Excel functions such as VLOOKUP and SUMIF
  • Explore Excel's logical functions in depth
  • Study how to create nested IF statements in Excel
  • Investigate Excel's Formula Auditing tools for troubleshooting
USEFUL FOR

This discussion is beneficial for Excel users, particularly those who are beginners or intermediate users looking to enhance their skills in creating conditional formulas and performing calculations in spreadsheets.

tkav1980
Messages
47
Reaction score
1
Im trying to set up a spread sheet for my chef but I am stuck.

Cell B2 = invoice total
Cell C2 = chemical total
Cell D2 = Sum(B2-C2)
Cell E2 needs to be...if cell d2 < 4000 then multiply by 1%, if 4000 or greater multiply by 2%.

Im very stuck on E2 and can't figure out how to make a formula work for this. IF anyone could help Id greatly appreciate it. I am not very good with excell, I can set up very basic formulas but this one has me stuck. Thank you in advance.
 
Computer science news on Phys.org
=IF(D2<4000,D2*0.01,D2*0.02)

=IF ( D2<4000 , D2*0.01 , D2*0.02 ) <-- with spaces added for readability

BTW, the Excel interface generated this for me; I just clicked on the Formulas page, clicked on Logical to indicate that I wanted logic functions such as "IF", and a popup window asked me for the arguments. I supplied the arguments, and it generated the text that got written into the cell.
 
Wow, Thanks! I was looking around in the formulas to see if I could find something. Thanks for the help!
 

Similar threads

MCNP6: Cell Volume Not Calculated - Assymetrical
  • · Replies 2 ·
Replies
2
Views
3K
Undergrad Momentum conservation for EM-Field/matter interaction
  • · Replies 3 ·
Replies
3
Views
1K
MHB Excel Question (asking for a friend)
  • · Replies 2 ·
Replies
2
Views
3K
Algorithm for creating unique groups of elements
  • · Replies 1 ·
Replies
1
Views
2K
High School What forces are required to tumble a block?
  • · Replies 16 ·
Replies
16
Views
2K
Find the length of one of the sides in a triangle
  • · Replies 4 ·
Replies
4
Views
2K
MATLAB Converting Excel formulae into Matlab code
  • · Replies 2 ·
Replies
2
Views
4K
Undergrad Did I figure-out z-translation of 2D-coordinates correctly?
  • · Replies 4 ·
Replies
4
Views
3K
Comp Sci An Introduction to Deep Learning and Modifying Code
  • · Replies 7 ·
Replies
7
Views
2K
Estimate the total harmonic distortion present
  • · Replies 6 ·
Replies
6
Views
6K