P
Phil Hageman
I need a formula to return three values:
If Then
blank blank
0 1
Thanks,
Phil
If Then
blank blank
0 1
Thanks,
Phil
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chip Pearson
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 [email protected]
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 [email protected]
C
Chrissy
=IF(ISBLANK(A1),"",IF(A1=0,1,IF(A1>0,(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(A1>0,(AM19-V12)/(P12-V12),"A1<0")))
is probably more like what you want - but change the last bit in quotes.
Chrissy.
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(A1>0,(AM19-V12)/(P12-V12),"A1<0")))
is probably more like what you want - but change the last bit in quotes.
Chrissy.
C
Chrissy
Chip Pearson wrote
Should be 1 as OP said
Assuming that my ^ lines up with your formula.
Chrissy.
--------------------------------^Phil,
Try something like
=IF(A1="","",IF(A1=0,0,(AM19-V12)/(P12-V12)))
Should be 1 as OP said
Assuming that my ^ lines up with your formula.
Chrissy.
C
Chip Pearson
Chrissy,
Yes, you're right. IT should be 1 not 0.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
Yes, you're right. IT should be 1 not 0.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
P
Phil Hagmen
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 [email protected]
.
P
Phil Hageman
Thanks for your Chrissy. Your first formula is
essentially the same as Chips. Works great!
essentially the same as Chips. Works great!