[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

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!
0
Hans de Jongh
Asked:
Hans de Jongh
1 Solution
 
skipper68Application 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now