Excel formula - should this be a macro?
 

Hi all,

I am trying to divide 1 number between several cells. Check the value
and verify the sum of those cells is the same as the beginning number.
my formula is as follows:

[Cell D22] =IF(N22<0,ROUND(C22/N22,0))
[Cell E22] =IF(N221,ROUND(C22/N22,0),0)
[Cell F22] =IF(N222,ROUND(C22/N22,0),0)
[Cell G22] =IF(N223,ROUND(C22/N22,0),0)
[Cell H22] =IF(N224,ROUND(C22/N22,0),0)
[Cell I22] =IF(N225,ROUND(C22/N22,0),0)
[Cell N22] =ROUNDDOWN(C22/10,0)

It's close to what I need, but not right yet. Please help.

Byron