Need help, for computers class we have to make this excel table for our grades. We have two cells side by side.. Refer to the workbook I attached. Basically, if in cell A3, the 'something 1' is selected from the drop down than I want B3 to be "A" with the formatting that applies if you select it manually now. I had a formula worked out, the IF statement but I can't seem to get it to work right.
Thanks,
lieb39
P.S. Sorry for putting the workbook in a zip file, its a extra step I know but Neowin won't let me upload the file otherwise.
Question
lieb39
Hello everyone,
Need help, for computers class we have to make this excel table for our grades. We have two cells side by side.. Refer to the workbook I attached. Basically, if in cell A3, the 'something 1' is selected from the drop down than I want B3 to be "A" with the formatting that applies if you select it manually now. I had a formula worked out, the IF statement but I can't seem to get it to work right.
Thanks,
lieb39
P.S. Sorry for putting the workbook in a zip file, its a extra step I know but Neowin won't let me upload the file otherwise.
Test1.zip
Link to comment
Share on other sites
0 answers to this question
Recommended Posts