SOLVED

Cell Variable as Part of If-Then Output Statement

%3CLINGO-SUB%20id%3D%22lingo-sub-2103989%22%20slang%3D%22en-US%22%3ECell%20Variable%20as%20Part%20of%20If-Then%20Output%20Statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2103989%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20rewrite%20the%20following%20if-then%20formula%3A%20%3DIF(F2%26lt%3B50%2C%20%22Student%20not%20on%20track%2C%20F2%25%20complete.%20%22%2C%22Student%20on%20track%2C%20F2%25%20complete.%22)%20When%20I%20run%20this%20I%20am%20trying%20to%20get%20the%20cell%20value%20from%20cell%20F2%20rather%20than%20the%20text%20%22F2%22.%20How%20do%20I%20designate%20F2%20as%20a%20variable%20in%20the%20output%20statement%20and%20not%20a%20text%20to%20be%20output%3F%20Output%20should%20read%3A%20%22%3CSTRONG%3EStudent%20not%20on%20track%2C%2038%25%20complete.%3C%2FSTRONG%3E%22%20The%2038%20would%20be%20the%20value%20in%20F2.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2103989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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 (New 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!