SOLVED

Cell Variable as Part of If-Then Output Statement

Copper Contributor

How do I rewrite the following if-then formula: =IF(F2<50, "Student not on track, F2% complete. ","Student on track, F2% complete.") When I run this I am trying to get the cell value from cell F2 rather than the text "F2". How do I designate F2 as a variable in the output statement and not a text to be output? Output should read: "Student not on track, 38% complete." The 38 would be the value in F2.

2 Replies
best response confirmed by Pedro007699 (Copper Contributor)
Solution

@Pedro007699 

=IF(F2<50,"Student not on track, "&F2/100&"% complete.","Student on track, "&F2/100&"% complete.")

Hans,

Thank you very much for your help. It worked like a charm. The student will get their report cards with comments!
1 best response

Accepted Solutions
best response confirmed by Pedro007699 (Copper Contributor)
Solution

@Pedro007699 

=IF(F2<50,"Student not on track, "&F2/100&"% complete.","Student on track, "&F2/100&"% complete.")

View solution in original post