if then statement, I think . . .

[cyber_troy1]

I'm looking to write a formula that returns the correct answer depending upon the number in D3.

if D3 is <50 then 5
if D3 is 50-60 then 6
if D3 is >60 then 7

 

[njimack]

=IF(D3<50,5,IF(D3<60,6,7))

 

[cyber_troy1]

Thanks.