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

Create a spreadsheet including IF formulas

Posted by Claire C.



Due date
Wednesday, 15th May 2013
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.
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.”
George C.
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