SharePoint Calculated Field Formula with Two Arithmatic Checks

Another SharePoint Calculated Field Example

If CapInt < 17 then field = AOP
if CapInt <24 but greater or = than 17 then field = BG
and if its 0 then blank
Matt PinkstonAsked:
Who is Participating?
kukdaiConnect With a Mentor Commented:
=IF(([CapInt]<17),"AOP ",IF(([CapInt]<24),"BG",""))
Matt PinkstonAuthor Commented:
Implemented Perfect!!!!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.