Multiple conditions in a formula
Help please. I have no idea how to combine formulas. I just want to round up this 6.83 to 7. What am I doing wrong? I don't want to use the "move over 2 decimal places" in the menu bar above because I need to take the rounded number and times it by a price per hour to get the Cost in another area of my sheet.
Best Answer

@Stacy Stoffel So, you can't reference the column you are in with a formula  that is why you get a circular ref. What you need to do then, is create a helper column, Helper_Round, for example. Calculate the round in there. Then, hide the helper column and show the column with the final calc.
Answers

@Stacy Stoffel This formula returns 7:
=MROUND(6.83, 1
so does=ROUND(6.83)
Not sure if this is going to solve your particular issue but if 6.83 is a fixed number, you can just plug that in directly like so:
=ROUND(6.83) * price_per_hour
You can also do this kind of thing too
=ROUND([ColumnName]@row) * [ColumnName]@row

Thanks Mary for responding!
I need to leave the formula =[Number of Devices]11 * 1 / 60 in the cell and combine it with the rounding formula. I don't want to insert another column. How do I combine what I have with =ROUND([Import & Discover Total Hours]@row)? I want to make both formulas into one total formula in one cell. Does that make sense?

=[Number of Devices]@row * 1 / 60 ...just changed my original formula to this

@Stacy Stoffel This worked for me:
=([Number of Devices]@row * 1/60) * ROUND(6.83)
If you run into issues, try entering just one half the equation  sometimes the issue is spacing and cut and paste between this forum (or other apps) and sheet can introduce odd characters or extra ones I've found.

So that 6.83 isn't a firm number. I will have additional entries where that number is fluid depending on the number of devices entered. So instead of 6.83 i just need the column to be rounded. I am trying this but get the error Circular Reference:

@Stacy Stoffel So, you can't reference the column you are in with a formula  that is why you get a circular ref. What you need to do then, is create a helper column, Helper_Round, for example. Calculate the round in there. Then, hide the helper column and show the column with the final calc.

Ok, I did do that already, but was hoping to combine them all into one formula.
Help Article Resources
Categories
Check out the Formula Handbook template!