mrps

Question

=if(a1>=36,a1=<47),''III'',If(a1>=48,a1=<59,''II'',if(a1>=60,''I'',''F''))) please correct to formula to prepare my school's resultsheet and grading sutdents progress report.

Anonymous · Answer

Use this as a reference
=IF(H4>=70,"A+",IF(H4>=60,"A", IF(H4>=55,"B+",IF(H4>=50,"B",IF(H4>=45,"C+",IF(H4>=40,"C",IF(H4<=39,"F")))))))

A+ >70 A >60 B+ >=55 B >=50 C+ >=45 C >=40 F <40

Related Topics:

Trustworthy Expert Solutions

Mrps =if(a1>=36,a1=<47),''III'',If(a1>=48,a1=<59,''II'',if(a1>=60,''I'',''F''))) please correct to formula to prepare my school's resultsheet and grading sutdents progress report.

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Ask a Question

Check Out the Mobile Browsers Report

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee

Grand Canyon Tech

Brad Brown

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Manual ZV1-00004.pdf....

Tds_wirelessopticaldesktop700...

X12-39326-01_NA_EN_XC_FR_IT_PT_ES.pdf....