Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

If/Then Calculation Script

Avatar

Level 2

I am having issues getting a calculation script written, so if anyone could help me out i would be much obliged.

What i have thus far is:

$ = ((SOWEDW1.rawValue)*2) + ((SOTHURSW1.rawValue)*2) + ((SOFRIW1.rawValue)*2) + ((SOSATW1.rawValue)*2) + ((SOSUNW1.rawValue)*2) + ((SOMONW1.rawValue)*2) + ((SOTUESW1.rawValue)*2)

This is completing the desired effect which is the Total is = to the value of all hours worked multiplied by 2($).

The way our system works is 1 hour on call = 2$, if you are on call for all 24 hours then you make an extra 2$ equaling 50$.

What i need is an if/then statement that says if any of those above values (SOWEDW1.rawValue, SOTHURSW1 etc.) have a user input value of 24, then the resulting $ for that day is 50$.

Im really just not sure where to go from here.

Thanks in advance.

0 Replies