You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Verify a Function

Forms Forms Layout Designer
Updated December 5, 2024
posted on December 5, 2024

Hi All,

I have this function.   =ADD(SUB(A,B),C)

My goal here is to first subtract A from B then add C. therefore 

Let A=30

Let B=60

30-60 result -30

Let C=50

Soi then I want to add C and result is 20

Is the function written out right?

0 0
replied on December 5, 2024

The math is correct but it does not match your description. I think you have the subtraction backwards. SUB(A,B)  is A-B (which is why you have "30-60 result -30"). If you want to subtract A from B, that would be B-A, so SUB(B,A).

0 0
replied on December 5, 2024

If your final answer should be 20, then yes your formula should be correct.  If your final answer should be 80, then you need to reverse A and B in the SUB() like @████████ indicated.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...