Claire C. (job poster) hired George C. (Tasker) to help with this task. Got a similar task you need done?
Open
Assigned
Completed

Create a spreadsheet including IF formulas

Posted by Claire C.

Location

Remote

Due date
Wednesday, 15th May 2013
Details
I need someone to add to an existing account keeping spreadsheet to include IF formulas (I think) to track spend per expense category.

Currently I have a spreadsheet which I have to manually input the worth of each expense into separate category columns which is cumbersome and easy to make mistakes.

You may need to create drop down boxes and IF formulas to complete this task. You must also be able to keep information confidential.
Reviews
Claire C. left a review for George C.
“George was an incredibly efficient and friendly runner. Thanks!”
George C. left a review for Claire C.
“Claire provided great job specs and was very courteous. Would love to work for her again.”
Assignee
George C.
(23)
100%Completion rate

The percentage of accepted tasks this Tasker has completed.

Task Activity
7 comments about this Task
Comments are now closed
Hi Claire, makes perfect sense
Excel guru here, can do this job easily. Please see my reviews!
Got it.. happy to assist. whats the deadline ??
Claire C.poster
Hi Ravi,
Please see the extra info in response to George's question.
Claire C.poster
Hi George,
Drop down boxes would be so I can itemise the type of expense (12 in total).

Example, we purchase $50 incl gst petrol at BP. In a supplier column, I type in BP, I could then choose 'petrol'
from a drop down menu. Then I guess this is where we would need some type of formula. If petrol, then take value (excluding gst) and duplicate in the relevant 'account' column.

I have perhaps 12 types of expenses and 6 'accounts' columns we track.

Does this make sense?
Task Assigned
0 new tasks