Nesting IF, AND, OR formulas

[tpeila]

So here is what I have that is not working
=IF(AND(G5<10),"10"), IF(AND(G5>40),"40")
And here is what I want it to do

if G5 is < 10 then = 10, if > 40 = 40, if between >10<40, G4*.55

Any help would be AWESOME!

 

[Jonmo1]

Re: Neesting IF, AND, OR formulas

Welcome to the board.

Try
=IF(G5<10,10,If(G5>40,40,G4*0.55))

 

[tpeila]

Re: Neesting IF, AND, OR formulas

WHOO HOO! Thank you SO much!

 

[Jonmo1]

Re: Neesting IF, AND, OR formulas

Glad to help, thanks for the feedback.