marksheet excel fail formula
Answers
Answered by
1
Answer:
ᴇɴᴛᴇʀ ᴛʜɪs ғᴏʀᴍᴜʟᴀ ɪɴ ᴄᴇʟʟ ᴄ4: =ɪғ(ʙ4<70,”ғᴀɪʟ”,”ᴘᴀss”) . ᴛʜɪs ᴍᴇᴀɴs ɪғ ᴛʜᴇ sᴄᴏʀᴇ ɪɴ ʙ4 ɪs ʟᴇss ᴛʜᴀɴ 70, ᴛʜᴇɴ ᴇɴᴛᴇʀ ᴛʜᴇ ᴡᴏʀᴅ ғᴀɪʟ ɪɴ ᴄᴇʟʟ ʙ4, ᴇʟsᴇ/ᴏᴛʜᴇʀᴡɪsᴇ ᴇɴᴛᴇʀ ᴛʜᴇ ᴡᴏʀᴅᴘᴀss. ᴄᴏᴘʏ ᴛʜɪs ғᴏʀᴍᴜʟᴀ ғʀᴏᴍ ᴄ4 ᴛᴏ ᴄ5 ᴛʜʀᴏᴜɢʜ ᴄ13.
Similar questions