Stupid/easy question: I have a long IF statement for an Excel tutorial I'm writing that aims to teach teachers how to use Excel for automated grading. It's essentially
for a LONG time. So, if the student's grade F4 = 96 and the value for an 'A' grade (J4) = 93,
for a long time. However, I was wondering about constant cell references, the dollar signs around the minimumgrade cell. I was wondering if there's an easy way to apply constant cell references to a lot of cells, all of which are on the same row. So, if the grades are J4, H4, I4, etc., is there a quick way to make instance of that letter in the formula have a dollar sign before and after? It's a lot to ask 80+ year old faculty to go through and press F4 before each reference they have to make constant. I've been fiddling with Find and Replace wild cards to no avail.
The formula I made (it's really simple) is this:
The ones needing dollar signs are all cells except F4.
Thanks in advance for your help!
Code:
IF(cell >= minimumgrade, lettergrade, IF(
Code:
=IF(F4>=J4,A,IF(F4>= ...
The formula I made (it's really simple) is this:
Code:
=IF(F4>=J4,J3,IF(F4>=K4,K3,IF(F4>=L4,L3,IF(F4>=M4,M3,IF(F4>=N4,N3,IF(F4>=O4,O3,IF(F4>=P4,P3,IF(F4>=Q4,Q3,IF(F4>=R4,R3,IF(F4>=S4,S3,IF(F4>=T4,T3)))))))))))
Thanks in advance for your help!