Thread: [Solved] Embedded IF AND OR Formula Problem
View Single Post
 
Old 08-26-2011, 06:51 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
ok, it's better now
i replaced IF(I15="NA";0;I15) with IF(I15="NA";D$1;I15)on all positions and works for all except E15, but i think this is the key condition to make it work.
you have to find a replacement for the red values to make it work for all range of conditions
Reply With Quote