I want to create a formula, or command to push data, or the results of a formula to an empty cell (with conditions)
Some say it can't be done, but some research has shown it can be done using VBA. see links- http://p2p.wrox.com/excel-vba/37251-excel-putting-result-formula-another-cell.html
http://boards.straightdope.com/sdmb/showthread.php?t=516941
I have zero VBA or coding experience.
View attachment New Expense Report working copy.xlsx
In the above sheet I want to push data in the following way:
When an employee enters mileage in column 'E' I want it to first take the number entered and multiply it by .5. Then take that result and push it to column 'F' and then also multiply that result by .13 and push that result to column 'G'
I need it to do this so that other data can be entered into cells in columns F and G when no data is entered into cells in 'E'.
How would I do this?
Some say it can't be done, but some research has shown it can be done using VBA. see links- http://p2p.wrox.com/excel-vba/37251-excel-putting-result-formula-another-cell.html
http://boards.straightdope.com/sdmb/showthread.php?t=516941
I have zero VBA or coding experience.
View attachment New Expense Report working copy.xlsx
In the above sheet I want to push data in the following way:
When an employee enters mileage in column 'E' I want it to first take the number entered and multiply it by .5. Then take that result and push it to column 'F' and then also multiply that result by .13 and push that result to column 'G'
I need it to do this so that other data can be entered into cells in columns F and G when no data is entered into cells in 'E'.
How would I do this?