View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Toolsoptionscalculation, set to automatic

Regards,

Peo Sjoblom

"Jason Southco" wrote in message
...
I am trying to copy/paste a formula using roundup to other cells but it is
not working. The formula, =ROUNDUP(M2*N2/W2, 0 ) works when I type it in.
However, when I copy/paste or use the fill handle, it copies it and it

says
=ROUNDUP(M3*N2/W2, 0) but the value it displays is the same as the first.

If
I manually type it in, it works, but copy paste displays the result to the
formula copied.