Urgent Need help :(
Watch
Announcements
Page 1 of 1
Skip to page:
Who is doing AS level ICT OCR coursework??
if u are please respond to my thread as i need ur help pleaseeeee
or if u are good in ict then please respond to the thread so i can respond u back
Thnaks
pleaseeeeeeee
if u are please respond to my thread as i need ur help pleaseeeee
or if u are good in ict then please respond to the thread so i can respond u back
Thnaks
pleaseeeeeeee

0
reply

0
reply
(Original post by Mactotaur)
I did it last year.
I did it last year.
but if u want to help me which would be great then plz respond
0
reply
Report
#6
(Original post by fatima1998)
ohh okay!!! but i dont think that the tasks are the same or similar coz 2015-2017 AS is changed
but if u want to help me which would be great then plz respond
ohh okay!!! but i dont think that the tasks are the same or similar coz 2015-2017 AS is changed
but if u want to help me which would be great then plz respond
0
reply
(Original post by Mactotaur)
What are your tasks this year?
What are your tasks this year?
task one- spreadsheet
task 2- graphics and word processing
task 3- website
task 4- data base
i am stuck on task 1
have already done task 2 and 3
0
reply
(Original post by shawn_o1)
Is it just using excel, or coding an excel task in VBA?
Is it just using excel, or coding an excel task in VBA?
and formulas for calculation within an excel
0
reply
Report
#11
0
reply
(Original post by Mactotaur)
Give us context. What calculations need to be done? What do you already have?
Give us context. What calculations need to be done? What do you already have?
u may b able to check that document
if u can see that document then i have done date and day and type of van and additional driver
needs to do total days hired
weeks
days
and quotation
0
reply
(Original post by shawn_o1)
There's an fx button in excel that you click, and you get a list of available functions. You can also search for a function by keyword.
There's an fx button in excel that you click, and you get a list of available functions. You can also search for a function by keyword.

i meant i have a task given and i am stuck on that
0
reply
Report
#14
(Original post by fatima1998)
Doc2.odt
u may b able to check that document
if u can see that document then i have done date and day and type of van and additional driver
needs to do total days hired
weeks
days
and quotation
Doc2.odt
u may b able to check that document
if u can see that document then i have done date and day and type of van and additional driver
needs to do total days hired
weeks
days
and quotation
Then Weeks is that number divided by 7.
0
reply
(Original post by Mactotaur)
Total days hired is just Return date-collection date, isn't it?
Then Weeks is that number divided by 7.
Total days hired is just Return date-collection date, isn't it?
Then Weeks is that number divided by 7.


i am stuck
can u like write the formula so i can work it out
0
reply
Report
#16
(Original post by fatima1998)
ermmmmm.... i got what u mean... but i dont know

i am stuck
can u like write the formula so i can work it out
ermmmmm.... i got what u mean... but i dont know


i am stuck
can u like write the formula so i can work it out
For Total Days Hired (or whatever else you're calling it):
=C6-C7
Say Total Days Hired is in D8.
For Total Weeks Hired:
=D8/7
0
reply
(Original post by Mactotaur)
Okay. Say that the cell ref. for Return Date is C6, and the cell ref for Collection Date is C7.
For Total Days Hired (or whatever else you're calling it):
=C6-C7
Say Total Days Hired is in D8.
For Total Weeks Hired:
=D8/7
Okay. Say that the cell ref. for Return Date is C6, and the cell ref for Collection Date is C7.
For Total Days Hired (or whatever else you're calling it):
=C6-C7
Say Total Days Hired is in D8.
For Total Weeks Hired:
=D8/7
but wait....
still on progress

soooo when i divided total weeks hired i got my answer in decimal 12.142...
is it right?
also there is a cell on days?
0
reply
Report
#18
(Original post by fatima1998)
OMGGGGGGGGGGGGGGGGGGGGGGGGGGG thanks a lot
but wait....
still on progress
soooo when i divided total weeks hired i got my answer in decimal 12.142...
is it right?
also there is a cell on days?
OMGGGGGGGGGGGGGGGGGGGGGGGGGGG thanks a lot
but wait....
still on progress

soooo when i divided total weeks hired i got my answer in decimal 12.142...
is it right?
also there is a cell on days?
0
reply
Report
#19
Can you screenshot your formulas and send it to me in a private message? It's easier to work with it if I know what you've got.
0
reply
(Original post by Mactotaur)
Might want to format the cell so it shows decimals to the nearest whole number.
Might want to format the cell so it shows decimals to the nearest whole number.

and what about the days?
0
reply
X
Page 1 of 1
Skip to page:
Quick Reply
Back
to top
to top