Thread: If/Then Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Phil Hagmen Phil Hagmen is offline
external usenet poster
 
Posts: 1
Default 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



.