Forum Discussion
Solved
Excel formula help
I am trying to perform a formula within a spreadsheet but cannot seem to find the right syntax for the function. I have a column of numbers within a simple budget management plan, G:19 through G:32. G:33 is the total dollars for the budget and G:34 would represent the actual amount received. How do I make G:35 which shows a difference that is a greater dollar amount from the value which is in G:34?
Thank you
- Hi Daniel
Hopefully I am following you:
G33 = total budget (e.g. 100,000)
G34 = actual money received (e.g. 80,000)
G35 = difference between G33 and G34
If this is the case, then maybe try =G34-G33 which gives you -20,000 (based on example above).
Is this what you mean? If not maybe please upload a sample file for us to see what it looks like?
Cheers
Damien
3 Replies
- Hi Daniel
Hopefully I am following you:
G33 = total budget (e.g. 100,000)
G34 = actual money received (e.g. 80,000)
G35 = difference between G33 and G34
If this is the case, then maybe try =G34-G33 which gives you -20,000 (based on example above).
Is this what you mean? If not maybe please upload a sample file for us to see what it looks like?
Cheers
DamienYes! That is exactly what I was looking for! Thank you! I was trying to use the COUNTIF command so apparently I was going about it in the wrong way. Thank you again!
Daniel
- Happy to help and all the best!
Cheers
Damien
