Q: Use of number formula
Numbers 3.6.2
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 |
|---|---|---|---|---|
| 7:00 | x | z | y |
I need to solve a problem.
The header 1 is a duration. If in header 2 or 3 is present x the value in header 1 will be copied in header 4. If x is not present in 2 or 3, the value in header 1 will be copied in header 5.
Can somebody help me with this?
Thank you
MacBook Pro with Retina display, OS X El Capitan (10.11.6)
Posted on Sep 17, 2016 4:26 AM
Hello quinn, unfortunately I am not able to describe the syntax error that I got (the red triangle)
but I can sho you what I did to solve the problem. First of all:
this is the application of your first formula suggestion: as shown the syntax is different from the your ( I have "," instead of ",")
I solved my problem with:
So I choose another parameter, reported in a single column, to move the info that i need.
So I thank you for your help because i went deeply in Numbers ( although the LEN function is still a mystery for me!)
Onopilot
Posted on Sep 20, 2016 2:41 AM







