Kindly assist me on How to find a formula for calculating a problem like this one below;
Cell A1 (Assignment 1Out of 20) Cell B1 (Assignment 2 out of 100) Cell C1 (Total Marks 40%)
19 88 (answer converted to 40%)
how do i find the formula that adds the 2 marks and convert the answer to 40%. I will be very grateful for your assistance.