Help with IF statements

**SpotsSpot** · 03-19-2018, 12:41 PM

Hi! I am a new user to the forum so I'm hoping I can explain my issue correctly. I have 4 columns of data and I need a formula to return "points earned" based on the data in each of those 4 columns.

Column A is my "Adjusted Achieved Rate". If Column D is equal to or higher than this rate, 0.5 points are earned.
Column B is my "3% Over Adjusted Achieved Rate". If Column D is equal to or higher than this rate, 1.0 points are earned.
Column C is my "6% Over Adjusted Achieved Rate". If Column D is equal to or higher than this rate, 1.5 points are earned.
Column D is my "2018 Achieved Rate"

I am trying to use a Nested IF statements to do this (there may be a more efficient way that I am unfamiliar with). The problem I am running into is that if points are earned in a different column, then they aren't earned in an 'earlier' column. For example, if 1.0 points are earned based on Column B, then the 0.5 points based on column A cannot also be earned. If 1.5 points are earned based on Column C, then the 1.0 points based on Column B and the 0.5 points based on Column A cannot also be earned.

Any help is much appreciated! And please let me know if there is a better way to do this in Excel.

Thank you!

**Olly** · 03-19-2018, 01:00 PM

Try:

Formula:

Please Login or Register  to view this content.

**Mazzaropi** · 03-19-2018, 01:02 PM

SpotsSpot, Good afternoon.

Try to use a solution using IF function as you requested:

E1 --> FORMULA -->

Please Login or Register  to view this content.

Try also to use:
E1 --> FORMULA -->

Please Login or Register  to view this content.

Please, tell us if they worked as you want?

I hope it helps.

**SpotsSpot** · 03-19-2018, 04:19 PM

Thank you - this is what I needed!!

**Mazzaropi** · 03-19-2018, 07:23 PM

SpotsSpot, Good evening.

Glad to have helped you.

Thanks for the feedback.

**jeffreybrown** · 03-19-2018, 08:25 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Also, for next time, please see Forum Rule #1 about proper thread titles and pick something a little more descriptive towards your requirements...

**Olly** · 03-20-2018, 04:21 AM

Originally Posted by jeffreybrown

Also, for next time, please see Forum Rule #1 about proper thread titles and pick something a little more descriptive towards your requirements...

Really? I thought it was spot on. All about If statements. What do you think would have been better?

**jeffreybrown** · 03-20-2018, 07:40 AM

Hi Olly,

Maybe a possible title update could be...

Nested IF statement to return "points earned" based on 4 columns of data

A title like this could possibly help the search efforts of others

I know this can be a subjective rule sometimes, but I also believe some thought can be put into the title especially when the title is in the body of your description.

**Olly** · 03-20-2018, 07:46 AM

Running the risk of insisting the entire question is asked in the title...

Anyhow - a digression from an (already solved) thread.

Help with IF statements

LinkBack

Thread Tools

Rate This Thread

Display

Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Re: Help with IF statements

Thread Information

Users Browsing this Thread

Similar Threads

Formula with multiple IF statements and IF AND statements

Reading If statements and formulating values from if statements

questions with if statements and nested if statements

Multiple nested IF statements and AND statements

Nested If statements / logic statements

Nested IF statements or CHOOSE statements needed for multiple conditions formula

[SOLVED] operator statements, shorting when reusing one of the statements?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions