| A | B | C | |
| 1 | Parameter | ||
| 2 | a | 5 | |
| 3 | b | 3 | |
| 4 | p | 0 | |
| 5 | q | 0 | |
| 6 | |||
| 7 | |||
| 8 | X | Y + | Y - |
| 9 | -5 | 0 | 0 |
| 10 | -4,5 | 1,31 | -1,3076696830622 |
| 11 | -4 | 1,80 | -1,8 |
| 12 | -3,5 | 2,14 | -2,14242852856286 |
| 13 | -3 | 2,40 | -2,4 |
| 14 | -2,5 | 2,60 | -2,59807621135332 |
| 15 | -2 | 2,75 | -2,7495454169735 |
| 16 | -1,5 | 2,86 | -2,86181760425084 |
| 17 | -1 | 2,94 | -2,93938769133981 |
| 18 | -0,5 | 2,98 | -2,98496231131986 |
| 19 | 0 | 3,00 | -3 |
| 20 | 0,5 | 2,98 | -2,98496231131986 |
| 21 | 1,0 | 2,94 | -2,93938769133981 |
| 22 | 1,5 | 2,86 | -2,86181760425084 |
| 23 | 2,0 | 2,75 | -2,7495454169735 |
| 24 | 2,5 | 2,60 | -2,59807621135332 |
| 25 | 3,0 | 2,40 | -2,4 |
| 26 | 3,5 | 2,14 | -2,14242852856286 |
| 27 | 4,0 | 1,80 | -1,8 |
| 28 | 4,5 | 1,31 | -1,3076696830622 |
| 29 | 5,0 | 0 | 0 |
| verwendete Formeln | |||
| Zelle | Formel | Bereich | N/A |
| A10:A29 | =A9+0,5 | ||
| B9:B29 | =WURZEL((1-($A9-$B$4)^2/$B$2^2)*$B$3^2)+$B$4 | ||
| C9:C29 | =-WURZEL((1-($A9-$B$4)^2/$B$2^2)*$B$3^2)+$B$4 | ||
ActiveSheet.Shapes.AddShape(msoShapeOval, 107.25, 48, 129.75, 15).Select
Deine Formel in den Zellen zeigt doch nur was an, wenn der Buchstabe in X19:X24 enthalten ist.
=UNIZEICHEN(9398)
