Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining formulas
I am trying to combine the =MIN formula with the IF function.
I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest of two cells multiplied by 1.4. Right now, if one cell is empty, the function still chooses the number in the occupied cell. I would like to add in an IF function that if BOTH cells are empty, then the cell should display "0.01". This saves me from going back and editing those cells by hand. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining formulas
One way
=IF(AND(A1="",B1=""),"0.01",MIN(A1,B1)*1.4 "Shae" wrote in message ... I am trying to combine the =MIN formula with the IF function. I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest of two cells multiplied by 1.4. Right now, if one cell is empty, the function still chooses the number in the occupied cell. I would like to add in an IF function that if BOTH cells are empty, then the cell should display "0.01". This saves me from going back and editing those cells by hand. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining formulas
Try this:
=IF(COUNT(A1:B1),MIN(A1:B1)*1.4,0.01) -- Biff Microsoft Excel MVP "Shae" wrote in message ... I am trying to combine the =MIN formula with the IF function. I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest of two cells multiplied by 1.4. Right now, if one cell is empty, the function still chooses the number in the occupied cell. I would like to add in an IF function that if BOTH cells are empty, then the cell should display "0.01". This saves me from going back and editing those cells by hand. Any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining formulas
Just add a ) in the end.
=IF(AND(A1="",B1=""),"0.01",MIN(A1,B1)*1.4) "Gaurav" wrote in message ... One way =IF(AND(A1="",B1=""),"0.01",MIN(A1,B1)*1.4 "Shae" wrote in message ... I am trying to combine the =MIN formula with the IF function. I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest of two cells multiplied by 1.4. Right now, if one cell is empty, the function still chooses the number in the occupied cell. I would like to add in an IF function that if BOTH cells are empty, then the cell should display "0.01". This saves me from going back and editing those cells by hand. Any ideas? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining formulas
Thanks! Both options got the needed result, but yours kept the numbers in
the same format I had previously set up. Perfect!! "T. Valko" wrote: Try this: =IF(COUNT(A1:B1),MIN(A1:B1)*1.4,0.01) -- Biff Microsoft Excel MVP "Shae" wrote in message ... I am trying to combine the =MIN formula with the IF function. I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest of two cells multiplied by 1.4. Right now, if one cell is empty, the function still chooses the number in the occupied cell. I would like to add in an IF function that if BOTH cells are empty, then the cell should display "0.01". This saves me from going back and editing those cells by hand. Any ideas? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining formulas
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Shae" wrote: Thanks! Both options got the needed result, but yours kept the numbers in the same format I had previously set up. Perfect!! "T. Valko" wrote: Try this: =IF(COUNT(A1:B1),MIN(A1:B1)*1.4,0.01) -- Biff Microsoft Excel MVP "Shae" wrote in message ... I am trying to combine the =MIN formula with the IF function. I am using =MIN(A1, B1)*1.4 to have the cell show the result of the lowest of two cells multiplied by 1.4. Right now, if one cell is empty, the function still chooses the number in the occupied cell. I would like to add in an IF function that if BOTH cells are empty, then the cell should display "0.01". This saves me from going back and editing those cells by hand. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining 2 Formulas | Excel Discussion (Misc queries) | |||
Combining formulas | Excel Discussion (Misc queries) | |||
Combining two formulas | Excel Worksheet Functions | |||
Combining formulas | Excel Discussion (Misc queries) | |||
Combining 2 Formulas | Excel Worksheet Functions |