ROUNDUP copy/paste and fill handle not working
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. |
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. |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com