If function Problem

[kalles]

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
1	8
2	7.5

	c
1	4
2	4

how i must write formula
thanks before

[Ken Puls]

I'll give you two different ways:

=IF(C1>=7,5;7,5,C1)

OR

=MIN(C1;7.5)

Hope that helps,