Help with IF Statement

minz_999

New Member
Joined
Nov 24, 2022
Messages
2
Office Version
  1. 365
  2. 2021
Platform
  1. MacOS
Hi all, I have been really struggling with this question I was wondering if anybody could help.

1). A student receives a UCPD award if they have completed 3 modules successfully and a UCAPD if they have completed 6 modules successfully. In column N enter a nested IF formula which determines whether a student gets a UCPD, UCAPD or neither.

The main bit which is confusing me is what if the number is more than 3 but less than 6, it needs to display UCPD but its not working. I am not sure what to do at the moment.

I have tried multiple IF statements however nothing seems to be working, this is what I have at the moment:
=IF(M3<3,"Neither",IF(AND(M3=3,M3>=5,"UCPD"),IF(M3>=6,"UCAPD")))
the column which the data is on:
Number of modules Passed
5
1
2
6
7
2
7
3
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top