IF(G39<=0, "", IF(G39<=7,3000, IF(G39<14,5000, IF(G3914,7500,"G39 is equal
to 14"))))
--
David Biddulph

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?