• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2661
  • Last Modified:

Sharepoint list calculated column value based on checkbox

Hi,
I am trying to add a formula to a calculated column I created in my Sharepoint list.  If the user checks my checkbox column then the calculated value is based on another field * some numbers, if not then the value is just 0.  Here is my syntax:

IF([Material Delay],([Labor (Hours)]*66)*.50),0)

Keeps saying my syntax is wrong or it is not supported.  Not sure what I'm doing wrong.
0
imstac73
Asked:
imstac73
1 Solution
 
Rainer JeschorCommented:
Hi,
yes, there is an error in your formula - you are missing one opening "(" (or you have one closing ) to much).

Your formula should either be
=IF([Material Delay],(([Labor (Hours)]*66)*0.5),0)

Open in new window

or
=IF([Material Delay],([Labor (Hours)]*66*0.5),0)

Open in new window


Textual:
IF Material Delay is checked, then take the number from Labour(hours) and multiply with 66 and multiply with 0.5 else its 0.
Or you can shorten it to x*66*0.5 == x*33

HTH
Rainer
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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