Jan 27 2021 02:46 PM
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.
Jan 27 2021 02:51 PM
Solution=IF(F2<50,"Student not on track, "&F2/100&"% complete.","Student on track, "&F2/100&"% complete.")
Jan 28 2021 05:39 AM
Jan 27 2021 02:51 PM
Solution=IF(F2<50,"Student not on track, "&F2/100&"% complete.","Student on track, "&F2/100&"% complete.")