Forum

Notifications
Clear all

HELP Keep getting error message

2 Posts
2 Users
0 Reactions
64 Views
(@cmapes211)
Posts: 1
New Member
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
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

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
Share: