Please provide excel functions Not just answers 44 The Fibon

4.4 The Fibonacci numbers are an interesting sequence of positive integers where each value is the sum of the previous two values. We begin with (4.3) Each successive value is then obtained from the formula (4.4) 3, 4, 5 F, F i-2 i-1 Create an Excel worksheet containing the first 20 Fibonacci numbers. Test each Fibonacci number to determine if it is odd or even. Place the Fibonacci numbers in column A, and the corresponding odd/even labels in column B.

Solution

Formula for fibonacci series A3 = Sum(A1+A2)

Formula to find if the fibonacci series number is even or odd C3 =IF(MOD(A1,2)=0,\"Even\",\"Odd\")

1		Odd
1		Odd
2		Even
3		Odd
5		Odd
8		Even
13		Odd
21		Odd
34		Even
55		Odd
89		Odd
144		Even
233		Odd
377		Odd
610		Even
987		Odd
1597		Odd
2584		Even
4181		Odd
6765		Odd