Excel formula - should this be a macro?

D

Dos Equis

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(N22>1,ROUND(C22/N22,0),0)
[Cell F22] =IF(N22>2,ROUND(C22/N22,0),0)
[Cell G22] =IF(N22>3,ROUND(C22/N22,0),0)
[Cell H22] =IF(N22>4,ROUND(C22/N22,0),0)
[Cell I22] =IF(N22>5,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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get around 30 argument limit of SUM function? 4
If condition for Blank Cell 4
MATCH with MAX formula question 5
adding problem with formulas 5
What is wrong with this formula? 10
Word macro that can call cells out of Excel for a find and replace 0
Match - #N/A 7
How to set the formula - part 2? 17

Top