Get instant live expert help on how to make excel not round
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need a hand with a nested if formula =IF($C$6="Round 1",'Round 1'!M7,IF($C$6="Round 2",IF($C$6="Round 3",IF($C$6="Round 4","")))) it works for round 1 but when i select round 2>4 it wont. i need to duplicate but not sure how to. Your help is appreciated.
Solved by Z. Y. in 14 mins
How to do excel round to nearest 1000 with a formula in excel
Solved by S. Q. in 28 mins
I have a formula =concatenate(SelectionTimes!H2," ",SelectionTimes!I2) to show the draft selection of the second round pick. I'd like to know how to make it like the first round where I don't have to manually change the H2 and I2 to H3 and I3 and have it so I can make it work easier.
Solved by A. D. in 19 mins
Please may I have assistance with creating a formula that will round up any decimal value however will not round any integers. The cells are formatted to not show any decimals.
Example:
2.000001 rounds up to 3
2.000000 remains as 2
Solved by G. H. in 28 mins
I have a formula that calculates a %, but I have a few that are less than 0%, and the cell gets an Error.. How can I make a "less than 0%, round up to 0%
Solved by E. J. in 26 mins