Help with =IF

[Markmus]

Hi Guys & Girls ^^

I am trying to get this one to work but it keep's reporting an error can you tell me what i am doing wrong?

=if(og($BM7>=0,$BM7<=999),1,if(og($BM7>=1000,$BM7<=2249),2,if(og($BM7>=2250,$BM7<=3749),3;if($BM7>=3750,4))))

Hoping u can help me

/Markmus

 

[FDibbins]

Assuming your "og" is "and", the only other problem I can see is in front of the last IF, you have ; instead of ,

 

[Michael M]

Try

=IF($BM7<=999,1,IF($BM7<=2249,2,IF($BM7<=3749,3,4)))