Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
64
Views
Topic starter
Need help to find IMSUB, IF, COUNTA, COUNTIF, and SUMIF I keep getting error messages. I have attached the assignment worksheet in word and my excel worksheet I have started with the data.
Posted : 10/09/2019 10:26 pm
Hi Chenise,
As I said in the Helpldesk ticket you raised, we won't do your assignment for you but you are welcome to browse through our site which will help you with the work you have to do.
If you get stuck we can try to help.
Why are you using IMSUB?
I think the formula you need in H5 is =IF(D5>5000,D5*G5,0)
https://www.myonlinetraininghub.com/excel-if-statement-explained
Check this for the other functions you need to use
https://www.myonlinetraininghub.com/excel-formulas
Regards
Phil
Posted : 11/09/2019 2:56 am