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...
SergeiBaklan
Jan 12, 2019Diamond Contributor
Hi,
That could be
=F22*IF(F22>=15000,0.06, IF(F22>9000,0.05,0))