M Manuel998 Member Jun 16, 2016 #1 Hi all, I am trying to get a result using an IF statement but this does not work: what I am trying to achive is if g6>12 and if its one of these colleges then return the relevant percentage. could I please ask any of you to help me out with this? Thanks Attachments Q1.xlsx 16.6 KB · Views: 10
Hi all, I am trying to get a result using an IF statement but this does not work: what I am trying to achive is if g6>12 and if its one of these colleges then return the relevant percentage. could I please ask any of you to help me out with this? Thanks
bobhc Excel Ninja Jun 16, 2016 #2 =IF(G7>12,D7,"Below Twenty"), placed in H7 and dragged down to suit, alter "Below Twenty" to suit your needs
=IF(G7>12,D7,"Below Twenty"), placed in H7 and dragged down to suit, alter "Below Twenty" to suit your needs
