Michelle has attended:
Excel Advanced course
'If' Formula
I have a table where I have a qty in column one, ie, 1192
I need to calcualte how many reels of 500 or 1000 I require, ie - this will be 1 x 1000 and 1 x 500 (with left overs)
how do I work this calcualtion out?
more examples:
Column A Reels of 500 reels of 1000
859 0 1
1865 0 2
2598 0 3
4450 1 4
Thanks
M
RE: 'If' Formula
Michelle
Can you please send a sheet or portion of a sheet that is laid out with the data you wish to analyze so we can have a closer look.
regards
david
RE: 'If' Formula
hi there
can you advise how I attach my spreadsheet to this?
RE: 'If' Formula
Hi Michelle,
No need, I understand what you're trying to do.
Assuming A is your total column, B is your 500 reel column and C is your 1000 reel column:
The formula you need for the 1000 reel column is:
=ROUND((A1-1)/1000, 0)
The formula you need for the 500 reel column is:
=IF(OR(MOD(A1,1000)>500,MOD(A1,1000)=0),0,1)
I have attached the file to this forum post (something only trainers are currently able to do due to security reasons).
Hope this solves your problem. This was fun to calculate.
Regards, Rich
