Voting
Category
real language
Bookmarking
Language Excel
(single cell version)
| Date: | 04/20/05 |
| Author: | AMi |
| URL: | n/a |
| Comments: | 1 |
| Info: | n/a |
| Score: |  (1.00 in 2 votes) |
/*26.09.2002 by AMi <mailto:amiundyvonne@web.de*/> amiundyvonne@web.de*/ /*Used german Excel-version: WENN means IF, ZEILE means ROW */ =WENN(ZEILE(A1)<100;100-ZEILE(A1) & " bottles of beer on the wall, " & 100-ZEILE(A1) & " bottles of beer, take one down and pass it around,";WENN(ZEILE(A1)=100;"no more bottles of beer on the wall, no more bottles, go to the store and by some more, 99 bottles of beer";""))
Download Source | Write Comment
Alternative Versions
| Version | Author | Date | Comments | Rate |
|---|---|---|---|---|
| standard version | Alejandro Julien | 04/20/05 | 3 | |
| version 4.x macro | Christian Schmidt | 04/20/05 | 0 | |
Download Source | Write Comment
Add Comment
Please provide a value for the fields Name,
Comment and Security Code.
This is a gravatar-friendly website.
E-mail addresses will never be shown.
Enter your e-mail address to use your gravatar.
Please don't post large portions of code here! Use the form to submit new examples or updates instead!
Comments
=IF(ROW(A1)<100,100-ROW(A1) & " bottles of beer on the wall, " & 100-ROW(A1) & " bottles of beer, take one down and pass it around,",IF(ROW(A1)=100,"no more bottles of beer on the wall, no more bottles, go to the store and by some more, 99 bottles of beer",""