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