Hi,

=IF(AND(G390, G39<=7),3000,IF(AND(G397, G39<=14),5000,if(G3914,7500)))

"tom" wrote:

I'm trying to have a formula do 3 scenerios in one cell and have a partial
formula working: IF(AND(G3930, G39<=7),3000) which equates to if cell G39 is
greater than 0 and less than or equal to 7 use 3000. I would like to
continue the formula that if G39 is greater than 7 and less than 14 use 5000
and if G39 is greater than 14 use 7500. How can I do this?