Combine formulas referencing the same cell without running into a circle reference

MarcRNelson

Is it possible to combine multiple formulas referencing the same cell without running into a circle reference? Similar to passing an object to a function.

I would like to combine the 3 formulas below for efficiency sake rather than creating additional columns.

=SUM([column name]24/ 1000)

=ROUND([column name]24, 1)

="$" + [column name]24 + "M"

Mike Wilday

Does that do the trick? 

="$" + Round([Column name]24/1000,1) +"M"

Mike Wilday

It assumes that you are referencing row 24 of whatever your column name is. 

MarcRNelson

Mike you are the man! This will be very helpful moving forward.

Mike Wilday

Glad I could help! Enjoy!