If formula HELP HELP HELP

[SavTeach]

how can I make this work?!?!?!? if (g4>=800,"","R"),if(h4>=800,"","M"),if(g4 and H4<80,"M/R","")

 

[kpark91]

=IF(g4<800,"R",IF(h4<800,"M",IF(AND(g4<80,h4<80),"M/R","")))

 

[FootyMan]

Edit: Beaten to it

 

[SavTeach]

it did not work. it is not catching the ones that need to be labeled M/R.... and I also made a mistake it should be if (g4 and h4<800 "M/R") if there a different formula I should use??? Also how do I add in there if they are blank don't do anything!!???

 

[kpark91]

SavTeach, could you try wording your problem and what results you are looking for?
Maybe, we can create a new formula that might work as intended.

Lastly, try this:

=IF(AND(ISBLANK(g4),ISBLANK(h4)),"",IF(AND(g4<800,h4<800),"M/R", IF(g4<800,"R", IF(h4<800,"M", ""))))

I don't believe there is any other formula you could use. The problem statement is simple as it is.

Lastly, if the cells are blank you should use ISBLANK() function.

 

[FootyMan]

=IF(AND(g4<800,h4<800),"M/R", IF(g4<800,"R", IF(h4<800,"M", "")))

 

[SavTeach]

in column "G" I have reading test scores in column "H" I have math test scores. (800 is the passing grade for each) if the student does not pass reading they will receive an R if they do not pass math they will receive an M if they do not pass both they will receive an R/M. (I have the R or M or R/M going in column F) hope this helps!!! thanks to all

 

[SavTeach]

when I put in the formulas you guys give me it comes up as inconstant!

 

[FootyMan]

kpark91's worked with mine. Are you sure you've copied it down the column properly?

Usually the inconsistent message means the formula is different to the one below/above etc

 

[SavTeach]

kpark91's worked with mine. Are you sure you've copied it down the column properly?

Usually the inconsistent message means the formula is different to the one below/above etc

GOT IT!! It was correct it was not picking up the correct cell number. When I copied it it stayed as the first cells I pasted it into!!! thank you all so much!!!