If function Problem
i have a time sheet.
C2 must have value if c1 bigger or equal to 7,5 =7,5
if c1<7.5 c2 must be have digits of c1
=if(c1>=7,5;7,5);=if(c1<7,5;c1)
for example
how i must write formula
thanks before
i have a time sheet.
C2 must have value if c1 bigger or equal to 7,5 =7,5
if c1<7.5 c2 must be have digits of c1
=if(c1>=7,5;7,5);=if(c1<7,5;c1)
for example
| c | |
| 1 | 8 |
| 2 | 7.5 |
| c | |
| 1 | 4 |
| 2 | 4 |
how i must write formula
thanks before
