|I'm not sure what you want as the final result.|
Let's say N2 = 9200. I know you want to calculate 9000*2.7%, but what do you want done with the 200?
If all you want is a maximum of 2.7% of 9000, then either one of these should work:
=IF(N2>9000, 243, N2*2.7%)
For N2 <=9000, you'll get N2*2.7%. For values > 9000 you'll get 243 which is 9000*2.7%.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03