Excel 2007 : If function Problem

[kalles]

book1.xlsx
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
for example
C
1 8
2 7.5
C
1 8
2 7.5
how i must write formula
thanks before

[npamcpp]

Hi kalles,

I'm afraid I don't quite understand what you want to achieve.

>> C2 must have value if c1 bigger or equal to 7,5 =7,5
That part is clear.

>>if c1<7.5 c2 must be have digits of c1
This needs more explanation. What do you mean by "digits of C1"? What are the "digits" of the value 8?

The formula in your attached workbook refers to empty cells:

=IF(C4>=7.5,7.5)

The cell C4 is empty.

Please post an example that reflects what you really want to achieve.

[kalles]

If c1 have a value bigger than 7,5 c2 cell must be 7,5
but if c1 have value smaller than 7,5 -c2 must have value equal to c1
i would like write those formulas together to c2 cell

i has explain in attachment too

[twiggywales]

=if(C1>=7.5,7.5,C1)

and your book (although you were refing an empy cell i think i got what you want)


book1 (1).xlsx

[jraj1106]

Hi
Try this:

=IF(C1>=7.5,7.5,C1)

[kalles]

Hi
Try this:

=IF(C1>=7.5,7.5,C1)

thanksss

[twiggywales]

did the work book i uploaded (a save of yours) not do what you need

[kalles]

did the work book i uploaded (a save of yours) not do what you need

its working
thank you so much
yabba dabbaaa duuuuuuuuuuu

[twiggywales]

glad to help remeber to mark the thread solved and tap the star button