How to Divide Across Sheets?

rbrice · 08/15/24

I am trying to take a value from the same column & row on a separate sheet and divide it by 160.

I tried to go super simple and just do ={Sheet reference}/160 and got invalid. Any ideas on the best way to do this?

Paul McGuinness · 08/15/24

You can use the absolute function,

=ABS({Test range}) / 160

That should do the trick for you

Thanks

Paul McGuinness

rbrice · 08/15/24

Thanks Paul,

I tried to do this and still got the #INVALID DATA TYPE error. I am going from one Text/number column to another.

Any other thoughts?

AravindGP · 08/16/24

Is the reference you created of a single cell in the source sheet? Is the value a number?

Answers