I am using the formula in excel which i want to use in vba. The formula in excel is :- =IF(C3=0,"Nil Forecast",IF(E3=0,"Nil Sale",F3/C3)).This formula fails when used in excel vba. Please suggest how can i use the same in vba or what corrections i have to do to run it sucessfully.




Yogesh

__________________
Yogesh

Try using evaluate yogesh

s = Evaluate("IF(C3=0,""Nil Forecast"",IF(E3=0,""Nil Sale"",F3/C3))")


http://vbadud.blogspot.com/2007/03/u...ns-in-vba.html

Cheers
Shasur



http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

The Evaluate("IF(C3=0,""Nil Forecast"",IF(E3=0,""Nil Sale"",F3/C3))")
statement is giving wrong result.

Yogesh