Thread: If/Then Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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