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?

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?

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?

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?

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?

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?