sara has attended:
Excel Advanced course
Formula
Can anyone help, I am having an absolute mental block!!!
I have a workbook and am trying to work out a formula to work out estimated income.
for example:
Name: No Of Visits @£530: Total Cost:
John Smith 12 £6360
Sara C-G 10 £5300
How do I enter the number of visits, and for Excel to automatically work out and fill in cell three that the cost will be £6360 or £5200 without me doing Autosum or getting out my trusty calculator!
I can't for the life of me remember!
Any help truly appreciated.
RE: Formula
Hi Sarah
Don't worry we all have mental blocks at times, thankfully, that's why we have the forum to help :)
A B C D
1 Name: No Of Visits Cost per visit Total Cost
2 John Smith 12 £530 =B2*C2
3 Sara C-G 10 £530 =B3*C3
The above example allows a different No of Visits and Cost per vist
If you want one cost to apply for all you can refer to an individual cell using an Absolute cell reference ($)
A B C
1 Cost per Visit £530
2
3 Name: No Of Visits Total Cost
4 John Smith 12 =$B$1*B4
5 Sara C-G 10 =$B$1*B5
Hope this makes sense and answers your question.
Regards
Dennis