Creating advanced calculated field in sharepoint

Hello,

I need help with a calculated field.. As im not an excel expert its pretty hard...:)

I have 2 fields
field1
Field2

I need a calculated field with the following output:
1 = field1 is empty
2 = field1 is not empty but smaller or bigger then field 2
3 = field1 is the same as field2

1 is easy 3 is easy but 2 is hard. And then putting everything in 1 field is even harder:)

=IF([Controle inkoopbedrag]=[Inkoopbedrag (ex btw)];"3")
=IF([Controle inkoopbedrag]<[Inkoopbedrag (ex btw)];"2")
=IF(ISBLANK([Controle inkoopbedrag]);"1")

thanks!
thanks!
Hans de JonghAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
skipper68Connect With a Mentor Application Development ManagerCommented:
Instead of trying to figure out "field1 is not empty but smaller or bigger then field 2", what if you just check if it is not empty and not equal to field 2
     =IF(AND(ISBLANK(field1)=FALSE,field1<>field2),2,"")

Then put them all together you put the next check in the false value
     =IF(ISBLANK(field1),1,IF(AND(ISBLANK(field2)=FALSE,field1<>field2),2,IF(field1=field2,3,"")))
0
 
Hans de JonghAuthor Commented:
thanks skipper!
0
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.