Excel formula

Hello, I need to add formula in Sheet2 column L to make sure it roundup column K, so in L3 it shows 3 if K3 is 2.3.

Also, is there a way to spread the column "Labor needed" to the different "resource" cells?. For example, if a task requires 3 resources, I need to assign the amount of hours each resource will spend in that task, so I need those hours to appear on the "Resource 1", "Resource 2", and "Resource 3" columns for that particular task. So is there a way excel can do this automatically in case there is a task that requires multiple resources (30 resources for example)?
Example3.1.xlsm
Iryna253Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongCommented:
in L3, use formula:

=IF(K3<1,1,IF(K3>$F$30,$F$30, ROUNDUP( K3,0)))
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
The following formula you can use in L3 and copy down but your second requirement if not clear, at least to me.

In L3
=IF(K3<1,1,IF(K3>$F$30,$F$30,ROUNDUP(K3,0)))

Open in new window

0
Ryan ChongCommented:
am I see it wrongly, it seems both suggestions are identical
0
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@Ryan
Yes you are right.
And in fact you answered first so OP should have been accepted your answer as an accepted solution.
Can you please use the Request Attention to reopen the question so that moderator can request op to change the accepted solution accordingly?

Regards.
0
Ryan ChongCommented:
cheers sktneer, thks for your understanding
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.