sum formula and if - ExcelBanter

Posted to microsoft.public.excel.programming

Mathieu[_3_] Mathieu[_3_] is offline

external usenet poster

Posts: 3

sum formula and if

Hi,

I am trying to make the vba make a small calculation without success. I have
tried the formula below.

What I want to do is : if (sum of AH2 to AH1000) is greater than ( 0 ) do
this, else do that.

Thanks!

Dim ca As Variant

'ca = "=sum(AH2:AH1000)"
'ca = "=SUM(R[2]C[33]:R[1000]C[33])"
'ca=FormulaR1C1 = "=sum(AH2:AH1000)"

If ca 0 Then
do this

Else

do that

End If
--
Mathieu

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula	PJ[_3_]	Excel Worksheet Functions	2	June 2nd 10 03:45 PM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible	blue[_2_]	Excel Discussion (Misc queries)	2	July 11th 07 06:08 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro	[email protected]	Excel Programming	1	July 20th 06 07:58 PM
Excel 2002 formula displayed not value formula option not checked	Dean	Excel Worksheet Functions	1	February 28th 06 02:31 PM
Commenting custom formula fields/formula on formula editor	Muxer	Excel Programming	2	July 24th 03 01:02 AM

All times are GMT +1. The time now is 11:29 PM.

Menu

About Us