Subtracting data from more then 2 columns
Hello,
I have been trying to subtract numerical data from three different columns, and I have tried
=[Submitted HRs]@row-[Lunch Time]@row-[Contracted HRs]@row and get invalid operation
I tried using parathesis
=([Submitted HRs]@row - [Lunch Time]@row) - [Contracted HRs]@row and get an invalid operation
I have also tried
=sum([Submitted HRs]@row-[Lunch Time]@row)-[Contracted HRs]@row) and get Unparsebale
Is there no simple formula for subtracting data?
BTW does it matter if one of the columns is a dropdown list of numbers?
Answers
-
Exactly how are each of the three columns being populated? It sounds like at least one of them is potentially storing text data.
-
Hi Paul,
submitted HR is a total from two other columns (a two-column subtraction formula)
lunchtime is via a form and has a drop-down of options
contracted hr is a formula based on which day of the week it is.
-
Are you able to provide the formulas? Also try wrapping each one in a VALUE function.
=VALUE([Column A]@row) - VALUE([Column B]@row)
-
-
Thanks Paul, that has worked prefectly
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!