If/Then Formula
 

I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil

If/Then Formula
 

Phil,

Try something like

=IF(A1="","",IF(A1=0,0,(AM19-V12)/(P12-V12)))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Phil Hageman" wrote in message
...
I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil

If/Then Formula
 

=IF(ISBLANK(A1),"",IF(A1=0,1,IF(A10,(AM19-V12)/(P12-V12))))

The cell you are testing is A1 - change it to what ever you want.

That does what you said ..... but ...... if A1 is < 0 or contains characters
then you get a "FALSE" as the result.

=IF(ISBLANK(A1),"",IF(A1=0,1,IF(A10,(AM19-V12)/(P12-V12),"A1<0")))

is probably more like what you want - but change the last bit in quotes.

Chrissy.


"Phil Hageman" wrote in message ...
I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil

If/Then Formula
 

Chip Pearson wrote
Phil,

Try something like

=IF(A1="","",IF(A1=0,0,(AM19-V12)/(P12-V12)))
--------------------------------^

Should be 1 as OP said

0 1

Assuming that my ^ lines up with your formula.

Chrissy.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Phil Hageman" wrote in message
...
I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil

If/Then Formula
 

Chrissy,

Yes, you're right. IT should be 1 not 0.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Chrissy" wrote in message
...
Chip Pearson wrote
Phil,

Try something like

=IF(A1="","",IF(A1=0,0,(AM19-V12)/(P12-V12)))
--------------------------------^

Should be 1 as OP said

0 1

Assuming that my ^ lines up with your formula.

Chrissy.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Phil Hageman" wrote in message
...
I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil

If/Then Formula
 

Thanks for your reply, Chip. Works great!
-----Original Message-----
Phil,

Try something like

=IF(A1="","",IF(A1=0,0,(AM19-V12)/(P12-V12)))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Phil Hageman" wrote in message
...
I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil


.

If/Then Formula
 

Thanks for your Chrissy. Your first formula is
essentially the same as Chips. Works great!
-----Original Message-----
=IF(ISBLANK(A1),"",IF(A1=0,1,IF(A10,(AM19-V12)/(P12-
V12))))

The cell you are testing is A1 - change it to what ever
you want.

That does what you said ..... but ...... if A1 is < 0 or
contains characters
then you get a "FALSE" as the result.

=IF(ISBLANK(A1),"",IF(A1=0,1,IF(A10,(AM19-V12)/(P12-
V12),"A1<0")))

is probably more like what you want - but change the last
bit in quotes.

Chrissy.


"Phil Hageman" wrote in message
...
I need a formula to return three values:

If Then
blank blank
0 1
0 (AM19-V12)/(P12-V12)

Thanks,
Phil


.