Microsoft Office Forums - View Single Post - [Solved] Using IF Function where logical test is for range of values

Thread: [Solved] Using IF Function where logical test is for range of values

View Single Post

Old

02-11-2017, 01:58 PM

guciolino

guciolino is offline

guciolino uses Mac OS X

Mac OS X

guciolino uses Office for Mac 2011

Office for Mac 2011

Novice

The original poster

Join Date: Feb 2017

Posts: 6

guciolino is on a distinguished road

Default

Quote:

Originally Posted by xor

View Post

How about:

=IF(A1<200000,"",IF((A1>=200000)*(A1<300000),0.02, 0.04)*(A1-200000))

Thank you,

This formula shows me Err:509

=IF(G21<200000,"",IF((G21>=200000)*(G21<300000),0. 02, 0.04)*(G21-200000))

Reply With Quote