Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Just a question if cell 2 held 51 1/8 instead, would you still want to
subtract 3/8? If you always want to the integer of the smallest value then you should use =INT(MIN(A1:A3)) -- Regards, Peo Sjoblom "GreenMonster" wrote in message ... yo da man! Thanks...now I feel stupid. "Niek Otten" wrote: =MIN(A1:A3)-(3/8) -- Kind Regards, Niek Otten Microsoft MVP - Excel "GreenMonster" wrote in message ... I'm trying to determine the lesser value of three seperate cells, and then subtract 3/8 from that value. Example: Cell 1 = 51 1/2 Cell 2 = 51 3/8 Cell 3 = 51 5/8 the function would determine that Cell 2 is the lesser of the three therefore returning of 51 3/8 - 3/8 = 51. Please help Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |