Continue the calculation but stops at 99 *

[DocAElstein]

Ok, I did that and that's wonderful but how can I change the spreadsheet so I don't have to keep dragging it down? Is that possible? I thought that what the "limit" entry is suppose to do automatically. Isn't it?

You could do that with a VBA Code.
But that is realy trying to run before you can walk.
Can you not just drag the formulas a long way down so that there is always enough. ?

The "limit" entry is just a value used in the formula.
The formulas give you no value ( "" ) or a value based on an equation depending on If the the condition is met
https://support.office.com/en-us/art...c-aa8bbff73be2

[DocAElstein]

.... I thought that what the "limit" entry is suppose to do automatically. Isn't it?

Look at this for example

Using Excel 2007 32 bit

Row\Col	F
95	=IF(G94>=$B$3,"",G94+1)

Worksheet: Sheet1

IF the value of cell G94 is greater than or equal to the calue in B3 ( the limit ) then the formula returns a value in the cell of ""
"" is just Excel's way of saying nothing.
Otherwise if that condition is not met the value returned to the cell is given by
( the value in cell G94 ) +1

[learning]

This is not the thread I started, what happened? It looks like mine was hijacked. This is not a continuation of page 1










_.___________________________________

Moderator Note ( 15th Jan 2019 ): Changed title so that clicking on page 2 works... added a * after 99 in original title

[learning]

Hello,????

[learning]

Ok, thanks again. I think at this point is to go to fiverr and find someone to fix it the way I want it for 5 dollars and just be done with it. Thanks again.

[DocAElstein]

Hello,????

Hello

[snb]

Ok, thanks again. I think at this point is to go to fiverr and find someone to fix it the way I want it for 5 dollars and just be done with it. Thanks again.

In that case you are not learning, Learning.

[learning]

I guess you're right snb, thanks for the observation.

[learning]

See snb,
It's a need vs. want vs. have to situation
I don't need or have to learn excel
I want to learn excel
Just because I paid someone to fix my spreadsheet doesn't mean I've stopped wanting to learn excel.
See there you posted a judgement like you know me and you don't.
Thanks again.