Hello friends,
I have a project in which I need to set a particular value of a cell:
for example:
I have a If the key of area 4 is in the form "P ...", the same value of area 1 is taken, but with a lower limit of 1 year and 0 months
o Example 1: if the key of area 4 is "P003" and the useful life of area 1 is 5 years and 3 months, copy in area 4 -->5 years and 3 months
o Example 2: if the key of area 4 is "P003" and the useful life of area 1 is 0 years and 8 months, copy in area 4 -->1 year and 0 months
How is it possible to set a minimum value for a cell?
Thank you so much,
camilla.
I have a project in which I need to set a particular value of a cell:
for example:
I have a If the key of area 4 is in the form "P ...", the same value of area 1 is taken, but with a lower limit of 1 year and 0 months
o Example 1: if the key of area 4 is "P003" and the useful life of area 1 is 5 years and 3 months, copy in area 4 -->5 years and 3 months
o Example 2: if the key of area 4 is "P003" and the useful life of area 1 is 0 years and 8 months, copy in area 4 -->1 year and 0 months
How is it possible to set a minimum value for a cell?
Thank you so much,
camilla.