Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2013, 01:22 PM
OTPM OTPM is offline Need help with a formula Windows 7 32bit Need help with a formula Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Why is E3+C4+D4 not a formula?
E3 is your opening balance.
C4 is your first withdrawal - if any.
D4 is your first deposit - if any.


You seem to be hung up on your original formula. It does not work for you - forget it.
I have provided you with a solution AND A FORMULA - why do you not want to use it?
Tony
Reply With Quote
  #2  
Old 02-06-2013, 01:26 PM
e_a_g_l_e_p_i e_a_g_l_e_p_i is offline Need help with a formula Windows XP Need help with a formula Office 2010 (Version 14.0)
Novice
Need help with a formula
 
Join Date: Sep 2010
Posts: 11
e_a_g_l_e_p_i is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi
Why is E3+C4+D4 not a formula?
E3 is your opening balance.
C4 is your first withdrawal - if any.
D4 is your first deposit - if any.
You seem to be hung up on your original formula. It does not work for you - forget it.
I have provided you with a solution AND A FORMULA - why do you not want to use it?
Tony
I'm sorry you don't think I am not taking your advice. a formula looks like this
=IF(B5="","",E4-C5+D5)

What formula that I can paste into a cell and drag it down will give me a running total?
I do not see your formula doesn't a formula start with a "=" sign??

Don't be insulted you are not giving me what I need. sorry

This is also a formula

=IF(DATEDIF(A9,B9,"y")=0,"",DATEDIF(A9,B9,"y ")&" years ")&IF(DATEDIF(A9,B9,"ym")=0,"",DATEDIF(A9,B9,"ym") &" months ")&DATEDIF(A9,B9,"md")&" days"
Reply With Quote
  #3  
Old 02-06-2013, 01:35 PM
OTPM OTPM is offline Need help with a formula Windows 7 32bit Need help with a formula Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Then just add an = sign before my formula!
And then drag it down the column to repeat it.
Just for information the = sign is not part of the formula it simply indicates to Excel that everything after the = sign is a formula.
Good luck.
Tony
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with a formula formula help rich_cirillo Excel 3 09-26-2012 11:41 PM
help with a look up or if formula beb1227 Excel 3 12-31-2011 01:08 PM
Need help with a formula Help with formula please. AndrewSE Excel 3 04-05-2011 08:50 PM
Need help with a formula If formula sixhobbits Excel 1 10-02-2009 08:02 AM
Help for formula dehann Excel 5 05-01-2009 10:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft