If a number in a column is less than 100 I want the function in the next column over to take that number and calculate 15 percent of that number. If it is over 100 then I want the calculation of that number to the calculation of 20 percent of that number.

Could you please tell me how this could be done?

Thank you!

What do you want to happen if the number equals100?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you believe the FCC ruled correctly by mandating net neutrality?

Discuss in The Lounge

Poll History