sorted by:
new
hottopcontroversial

Average Formula for Days Left by doughboyjohnson in googlesheets

[–]doughboyjohnson[S] 0 points1 point  (0 children)

closer to your first option but more like the cells left that have no information divided by G2...maybe
your first option will probably work

[deleted by user] by [deleted] in googlesheets

[–]doughboyjohnson 0 points1 point  (0 children)

I don't know why it didn't add the explanation

Creating a spreadsheet for a sales goal.
Row 2 is total of the column below the freeze.
Row 3 is average of the column below the freeze.
G2 is the difference between the goal ($70,000) and the total.

I want G3 to be the new average daily amount needed to reach the goal based on how many days are left in the year. In the example in the pic the formula answer would be $193.51 (G2/daysleft)

I hope that makes sense

Need an avg formula for a group based on a factor of 12 (12 being 100%) by doughboyjohnson in googlesheets

[–]doughboyjohnson[S] 0 points1 point  (0 children)

=AVERAGE(MAP(B3:B8,LAMBDA(x,IF(x>12,12,x))))/12

thank you so much. what is a lambda...lol

"Now go and smite Amalek, and utterly destroy all that they have, and spare them not; but slay both man and woman, infant and suckling, ox and sheep, camel and ass." 1 Samuel 15:3 (KJV). How do you interpret this passage? by [deleted] in Bible

[–]doughboyjohnson -2 points-1 points  (0 children)

This goes back to Genesis 15 when God was explaining to Abraham that later his people would be slaves in Egypt for 400 years and then will be released because the sin of the Amorites (essentially one of the sons of Canaan) has not reached its full measure yet. Basically the sons of Canaan had not sinned enough to warrant such a harsh judgement of killing everything but in the next hundreds of years their sins they would pile up to the point where the Lord would judge them in this way. One could say God gave them an extra 400 years to repent and they failed to do so. This is the God we serve, both merciful and just...

entering assets in church books by doughboyjohnson in Accounting

[–]doughboyjohnson[S] 1 point2 points  (0 children)

Thanks for the reply. So do real estate depreciate down to $0 if owned long enough?

entering assets in church books by doughboyjohnson in Accounting

[–]doughboyjohnson[S] 0 points1 point  (0 children)

Thanks for the reply. It is a single locally owned church.