If function Problem

kalles

New member
Joined
Apr 23, 2012
Messages
3
Reaction score
0
Points
0
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
c
18
27.5
c
14
24

how i must write formula
thanks before​
 

Attachments

  • book1.xlsx
    9.5 KB · Views: 15
Top