Thread
:
% variance calculation - amended
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
% variance calculation - amended
Check the formula you have when exptype is not e. Is it syntactically
correct? Specifically, check the parenthesis use.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article .com,
says...
Sub Macro2()
Dim exptype
exptype = InputBox("Enter e if expense type.")
If exptype = "e" Then
ActiveCell.FormulaR1C1 = "=-(RC[-1]/RC[-2]-1)"
Else
ActiveCell.FormulaR1C1 = "=RC[-1]/RC[-2]-1)"
End If
End Sub
Pls help - why i'm not getting any result if exptype is not equal to e
thxs
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta