I have the following formula in google sheets, it is working, but not 100%, in Column G I will only add a value now and then, but when I do, it change all the column I entry before to the new value in column G, and it should not, it must keep them the same.
=IF(G2<>"", ROUND(INDIRECT("G" & MAX(FILTER(ROW(G:G), G:G<>"", ROW(G:G)<=ROW()))) * INDIRECT("D" & ROW()), 2), I2)
here s the link to google sheet
https://docs.google.com/spreadsheets...it?usp=sharing
Where is the formula?
What do you want this formula to do?
Ok here is the formula again
=IF(G2<>"", ROUND(INDIRECT("G" & MAX(FILTER(ROW(G:G), G:G<>"", ROW(G:G)<=ROW()))) * INDIRECT("D" & ROW()), 2), I2)
What this formula must do is.
in column G I will add one or two times per month data into it, but every day I will add data and then column I must multiply D with last entry of column G, and when I add new entry into column G it must not change column I aboverows, at the moment it change every thing in Column I to new value of Column G
Herre is the correct file
https://docs.google.com/spreadsheets...it?usp=sharing
To make sure that I understand the value in I4 should be 21.2 (=D4*G3), the value in I5 should be 26.5 (=D5*G3) and the value in I18 should be 22.61 (=D18*G17)
If so then here is a formula that I feel will work if pasted into cell I3 and copied down:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
When drag doiwn gives thisd error Error
Did not find value '2' in LOOKUP evaluation.
Yes, I saw the formula in your first post. What cell is it in?Originally Posted by hendrikbez
I can only guess that google sheets needs to have this treated as an array formula.
Here is how it works in Excel.
The formula @JeteMc gave you will work with a small modification. Delete everything in cell I3 and below. Add the following formula:
.Formula:Please Login or Register to view this content.
Does this give you the results you are looking for?
It is only working in excel I did try it in sheets, getting this error "Did not find value '2' in LOOKUP evaluation."
as in my formlua I do not use row numbers, as i am using this as a private self app on my phone.
row 17 is where I add the new units I just got, so if in "G" there is a entry, then I must be blank
Last edited by hendrikbez; 06-09-2023 at 01:03 AM.
Did try to change it , but it givers me error "Array result was not expanded because it would overwrite data in I17." row 17 isd where I add thekoste in, and then i17 will be blank
also i do not use rownumbers as i am using this in a private app on my phone.
row 17 is where I add the new units I just got, so if in "G" there is a entry, then I must be blank
Last edited by hendrikbez; 06-09-2023 at 01:02 AM.
The error message you are receiving is because you didn't delete everything in column I (I3:I) before entering the formula in I3.
Column G is where you add the Koste and as far as I can see, has nothing to do with I17 being blank (R0.00).
I'm not sure I understand exactly what you are after. I've attached a copy of your sheet here. If this is not what you want, please manually enter the results in column J.
Thank you, it is working, now i must just get it to work from my app
after testing more, it chance all the data values in I
[url]https://docs.google.com/spreadsheets/d/1AD9IEhbWArgAJ-bMVL2jBkevqtFMPLX1ii0MG7aby3w/edit?usp=sharing[/url
If I add a new value in G, then it change all value in I above to new vlaue of G
Last edited by hendrikbez; 06-09-2023 at 12:29 PM.
I'm sorry, but I'm having difficulty grasping the underlying logic of your spreadsheet. It appears that you have 3 different formulas in column D, possible missing entries for 1 May in columns E and F, inconsistent and missing formulas in column G, and your sum ranges in column H don't seen correct.
Perhaps someone else may be able to help you. Good luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks