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

MarcRNelsonMarcRNelson ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
03/15/18 Edited 12/09/19

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"

Comments

  • Mike WildayMike Wilday ✭✭✭✭✭

    Does that do the trick? 

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

  • Mike WildayMike Wilday ✭✭✭✭✭

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

  • MarcRNelsonMarcRNelson ✭✭✭✭✭

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

  • Mike WildayMike Wilday ✭✭✭✭✭

    Glad I could help! Enjoy! 

Sign In or Register to comment.