Hi,
I,am wanting to write a function so that in cell B2 it will start at $10 and automatically add $5 until cell D gets a number 1
At the moment i have =IF(D2<=1,10,IF(D2>=1,10+5))
Cell E is what it should be, I have attached an example, I hope someone can help. Thanks
Last edited by Jabbaman; 06-14-2021 at 06:56 PM.
Sorry, delete first, but still don’t know what you are asking for
Last edited by wk9128; 06-13-2021 at 08:11 PM.
Hi wk9128,
Thanks for replying.
In Cell B I would like to start at $10 and if Cell D doesn't have the number 1 in it keep adding $5 until it does then restart the process again.
Not sure if that helps, I do have an IF function already there but it's not adding up correctly.
Cheers
Try in B2:
=IF(OR(D1=1,ISTEXT(D1)),10,B1+5)
Quang PT
Or:
=IF(N(D1)>1,B1+5,10)
Hi all,
Both formula's keep adding B cell to $10 and not adding $5 when cell D is not number 1
So in cell B2 i want to start at $10 and if D2 is not number 1 you add $5 to B3($15) and if D3 is not number 1 add $5 to B4($20) and so forth until D cell has number 1. Then start again at $10 in cell B. Hope that is a bit clearer. Thanks for replying.
I guess you mean add to the total you are calculating in E
so this in column E starting at E2 and filling down
=IF(N(D1)>1,E1+5,10)
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Hi scottiex,
Thanks for replying. The example in E cells are what I need it to be in B cells, i entered those manually as an example of what I'm wanting.
Cheers
Yes, my formula gave those numbers.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
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
In B3
=IF(D2=1,10,B2+5)
Thanks to everyone who helped, formula solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks