Thread
:
Macro Help!!!
View Single Post
#
3
Posted to microsoft.public.excel.programming
Ardus Petus
external usenet poster
Posts: 718
Macro Help!!!
sub tester
Var vResult as Variant
vResult = Iif(Range("E2")=0, _
"? RT = " & format(F2,"###.00"), _
Range("C2").Value
end sub
a écrit dans le message de news:
...
Forgive me for the double post. I had posted this question earlier in
the general excel usegroup, then saw there was programming group and
thought it belonged in here?
I'm trying to create a macro that will execute the funcyion below on a
three columns of data (C, E,F). The columns can vary in length from 26
to 60+ entries.
How do go about doing this?
=IF(E2=0,"? RT = "&TEXT(F2,"###.00"),C2)
Any help is very much appreciated.
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus