Forum Discussion
Dadojohn
Jan 12, 2019Copper Contributor
simple "if" formula that i cant work out.
Hi, Can some please write the "if" formula for below. Thanks. If F22 is equal to or greater than 9000 but less than 15000 then put 5% of the value of F22 into E25. If F22 is equal to or gre...
Eva Vogel
Jan 12, 2019Iron Contributor
Hello, I tested it and here’s my screenshot for you. If you enter a number in a2 you can the result in d2. Additionally you can refer to another cell in f22 with „=d2“ . Greets, Eva