u/vortex_homy

This is my formula

=SUMIF(G2:G18,">2499.9")*0.1

Im trying to find 10% of any cell greater than or equal to 2500 (i only use whole numbers). That's the idea.

Now, I'm trying to find 5% of any cell in between 499.9 and 2499.9, and put it all together in a sum just like the previous formula. I'm inexperienced in Google sheets and so I tried some of my own figuring out, but it did not work.

How do i do this?? im not on google sheets much, but i wanted to do something like this

=if(AND(I2:I18<500),I2:I18/0.03)

explained:
if any cell in this row is less than 500, then multiply it by 0.03
and then somehow get the sum of all of them put together at the end in this box

EDIT:
this has been fixed, however i was wondering what to do if i wanted to do the same for a value in between 500 and 2500?