help with an IF formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan M - 24 Jan 2006 11:13 GMT

I have the follwing code which sets a formaula in a specific column

With Margin
.FormulaR1C1 = "=SUM(RC[-1]-RC[-3])"
'.Value = .Value
End With

However some of the values in the C[-3] column are blank and so neagative
figures show as a result. I need to amend the formula to include an if
function which says that if the [-3] column is blank then return a zero as
the result

Reply to this Message

Bob Phillips - 24 Jan 2006 11:57 GMT

Your description doesn't make sense to me, but here is what you said

.FormulaR1C1 = "=IF(RC[-3]="""","""",RC[-1]-RC[-3])"

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

> I have the follwing code which sets a formaula in a specific column
>
[quoted text clipped - 7 lines]
> function which says that if the [-3] column is blank then return a zero as
> the result

Reply to this Message