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
I'll give you two different ways:
=IF(C1>=7,5;7,5,C1)
OR
=MIN(C1;7.5)
Hope that helps,
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks