Hello, I am trying to complete a project and am stumped with a needed formula. I would appreciate any help. If the amount in cell F25 is greater than the amount in E10 then the difference would go into E24.
Thank you in advance your responses.
Hello, I am trying to complete a project and am stumped with a needed formula. I would appreciate any help. If the amount in cell F25 is greater than the amount in E10 then the difference would go into E24.
Thank you in advance your responses.
Last edited by azgal; 06-06-2014 at 10:57 PM.
Try this
in E24
=IF(F25>E10,F25-E10,"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi azgal,
Check this formula and hope this helps you :
E24 = IF(F25>E10,F25-E10,0)
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Thank you so much!! It worked!
Last edited by azgal; 06-06-2014 at 10:09 PM.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
AlKey and pareshj, thank you so much. Both formulas worked but I also need to have it that the amount it F25 does not exceed E10. I hope this makes sense. Thank you for helping me.
Saarang84, the formula above works and puts the correct value in E24 but if F25 exceeds E10 I would like the value of E10 in F25
You can't change value in F25. Formulas in Excel do not change values in other cells. It only calculates values in the cell where formula is written.
Azgal
Inserting a number in a formula cell will automatically remove the formula.
If you want a formula and number input in the same sell you will need a VB code to manage that.
Would it be possible then to have the formula in F25 where that if it is greater than E10 then the value in E10 is used in F25 and the difference is put in E24?
Thanks for the title change
Last edited by FDibbins; 06-07-2014 at 12:10 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Looks like the values of E10, F25 and E24 are inter-dependent. Without knowing the context in which these fields are used and calculated, it is difficult for us to give you any solutions. Can you post a layout of your workbook with sample data (insensitive) for us to help you further?
And do remember to follow Ford's advice to change your thread title.
https://www.dropbox.com/s/qixg5d10vx...%20Sample.xlsm
Saarang84, here is a copy of the worksheet. Thank you
azgal please upload your file to the forum, not all members can access file-hosting sites (Company firewalls and stuff)
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks