If/Then Formula

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
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 (e-mail address removed)
 
=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.
 
Chip Pearson wrote
Phil,

Try something like

=IF(A1="","",IF(A1=0,0,(AM19-V12)/(P12-V12)))
Click to expand...
--------------------------------^

Should be 1 as OP said

Assuming that my ^ lines up with your formula.

Chrissy.
 
Chrissy,

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
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 (e-mail address removed)




.
Click to expand...
 
Thanks for your Chrissy. Your first formula is
essentially the same as Chips. Works great!
 
Back
Top