Jan 12 2019 03:57 AM
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 greater than 15000 then put 6% of the value of F22 into E25.
Jan 12 2019 04:01 AM
Hi,
That could be
=F22*IF(F22>=15000,0.06, IF(F22>9000,0.05,0))
Jan 12 2019 04:20 AM
Jan 12 2019 04:21 AM
Jan 12 2019 05:12 AM
Hi @Dadojohn
try this:-
=IF(AND(F22>=9000,F22<15000),E25+F22*5/100,IF(F22>=15000,E25+F22*6/100,"N/A"))
if not get ur solution, than share some sample data
Regards
Naveen
Jan 12 2019 05:14 AM
Hi @Dadojohn
try this:-
=IF(AND(F22>=9000,F22<15000),E25+F22*5/100,IF(F22>=15000,E25+F22*6/100,"N/A"))
if not get ur solution, than share some sample data
Regards
Naveen