I need to know how to create a formula to handle a condition in a single cell. Currently I have: =IF(G3=500,12,""))*G3 This is not quite right. What I need to take into account is: if G3 is greater than or equal to 500 = multiple the first 500 x 35, then multiply the remainder x 12. How do...