VBA for IF formulas

[newshound12]

=IF(DO32="",0,IF(CE31+DO32>DO35,B32,IF(CE31+DO32<DO36,-B36,"0")))

=IF(DO41="",0,IF(CE40+DO41>DO44,B41,IF(CE40+DO41<DO44,-B45,"0")))

=IF(DO50="",0,IF(CE49+DO50>DO53,B50,IF(CE49+DO50<DO53,-B54,"0")))

These formulas start in DO32 and end in DO923.
Each are 9 rows apart.
Need a macro to run these formulas and convert them to values

 

[DanteAmor]

The formula was deleted by the forum editor, add a space before and after each symbol < > and paste again your formula.

=IF(DO32="",0,IF(CE31+DO32 > DO35,B32,IF(CE31+DO32

 

[Michael M]

Can you provide the complete formula....I'm guessing they use an " < " sign, which will require a space either side of it to make it appear.
But it's simply the same as the last answer I provided but including the new formula

Sub MM1()
Dim r As Long
Application.ScreenUpdating = False
For r = 32 To 923 Step 9
    With Range("DQ" & r)
        .Formula = "=HH" & r - 1 & "+HH" & r & "+HH" & r + 3 & "+HH" & r + 4 & ""
        .Value = .Value
    End With
Next r
Application.ScreenUpdating = True
End Sub

 

[newshound12]

=IF(DO32="",0,IF(CE31+DO32>DO35,B32,IF(CE31+DO32<DO35,-B36,"0")))
=IF(DO41="",0,IF(CE40+DO41>DO44,B41,IF(CE40+DO41<DO44,-B45,"0")))
=IF(DO50="",0,IF(CE49+DO50>DO53,B50,IF(CE49+DO50<DO53,-B54,"0")))

Probably my fault copying it from another sheet

 

[Michael M]

Is it to be done in conjunction with the other formula in the previous macro ??

 

[newshound12]

different column

 

[newshound12]

keeps getting chopped up.
=IF(DO32="",0,
IF(CE31+DO32>
DO35,B32,
IF(CE31+DO32<
DO35,-B36,"0")))


=IF(DO41="",0,
IF(CE40+DO41>
DO44,B41,
IF(CE40+DO41<
DO44,-B45,"0")))


=IF(DO50="",0,
IF(CE49+DO50>
DO53,B50,
IF(CE49+DO50<
DO53,-B54,"0")))

 

[Michael M]

Are you putting a space either side of the < > signs ?
AND
you only need to post the first occurence of the formula, not what will be on the other lines

 

[Michael M]

This still doesn't seem right -B36 ??

=IF(DO32="",0,IF(CE31+DO32>DO35,B32,IF(CE31+DO32<DO35, -B36,"0")))

 

[newshound12]

No space.
Copied formula from worksheet.
Formula works on work sheet.
Need to get rid of formulas slowing up worksheet.