# excel formula calculation - how to insert the right formula

1. ## excel formula calculation - how to insert the right formula

Hello master of the excel world (: would you be able to help me with my formula?
I'm new to excel and having a problem doing a formuila on my attached excel.

Any help would be appreciated

Thanks,
Manila.Boracay

2. ## Re: Excel Formula - Help! Help! Help Please

Hi,

Formula

=IF(SUM((C6-E7 + C8)-B3)>16,67;SUM((C6-E7+C8)-B3);16,67)

3. ## Re: Excel Formula - Help! Help! Help Please

Hi and welcome to the board. Unfortunately,

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

4. ## Re: Excel Formula - Help! Help! Help Please

Hello,
I tried the formula below but its giving me an error!

=IF(SUM((C6-E7 + C8)-B3)>16,67;SUM((C6-E7+C8)-B3);16,67)

5. ## Re: Excel Formula - Help! Help! Help Please

JieJenn,

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

6. ## Re: excel formula calculation - how to insert the right formula

Thank You JieJenn I actually only needed the formula like the one below but for some reason its giving me an error. maybe its missing something.

=IF(SUM((C6-E7 + C8)-B3)>16,67;SUM((C6-E7+C8)-B3);16,67)

8. ## Re: excel formula calculation - how to insert the right formula

Manila, as you do not see fit to react to the demands, and you have visited the thread long after my last post, I will close the thread

You also cross posted at http://www.mrexcel.com/forum/showthread.php?t=592813

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

As you are clearly not interested by Forum rules, I will ive you some time to think it over

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1