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?
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.Originally Posted by learning
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
Last edited by DocAElstein; 01-24-2017 at 03:14 AM.
….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
If you are my enemy, we will try to kick the fucking shit out of you…..
Winston Churchill, 1939
Save your Forum..._
KILL A MODERATOR!!
Look at this for example
Using Excel 2007 32 bit
Worksheet: Sheet1
Row\Col
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
Last edited by DocAElstein; 01-23-2017 at 09:55 PM.
….If you are my competitor, I will try all I can to beat you. But if I do, I will not belittle you. I will Salute you, because without you, I am nothing.
If you are my enemy, we will try to kick the fucking shit out of you…..
Winston Churchill, 1939
Save your Forum..._
KILL A MODERATOR!!
Posting Permissions
Reply With Quote
Bookmarks