Solved Excel Formula Help Excel 2010

September 20, 2012 at 12:35:02
Specs: Windows 7
Need help with the below excel formula to ensure the maximum value doesnt exceed 1200 - Can anyone help?

=IF(AB14>59,Z14+1,ROUND(Z14+AB14/100+0.0005,2))

Thanks
Mike
xxxxxx@xxx.xxx

edited by moderator: email address deleted


See More: Excel Formula Help Excel 2010

Report •

✔ Best Answer
September 20, 2012 at 15:37:03
Ok, so did my suggested formula wok for you or not?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.



#1
September 20, 2012 at 13:15:20
Please do not include email addresses in your posts.

We do not want this site to become known as a place where email addresses can be harvested. Once the bad guys start hanging around, we'll be open to all sorts of security issues.

I have deleted the email address from your post.

DerbyDad03
Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
September 20, 2012 at 13:29:55
I'm not quite clear on what you are looking for.

Are you saying that you never want the result of the formula to be greater than 1200?

In other words, neither Z14+1 nor
ROUND(Z14+AB14/100+0.0005,2) should ever be greater than 1200?

If so, try this:

=IF(AB14>59, IF(Z14+1>1200, 1200, Z14+1), IF(ROUND(Z14+AB14/100+0.0005,2)>1200, 1200, ROUND(Z14+AB14/100+0.0005,2)))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
September 20, 2012 at 13:35:05
Thanks,
The total should never be more than 1200 -


Report •

Related Solutions

#4
September 20, 2012 at 15:37:03
✔ Best Answer
Ok, so did my suggested formula wok for you or not?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question