Need help with a Macro

[randy_tn]

I need to compare the contents of (B:8) and (B:10) if the value of (B:8
is .35 then do nothing but if it is greater than .35 I need to put a
"*" in (N:5).


Can somone PLEASE help me with this???
:confused

 

[Frank Kabel]

Hi
why not a formula in N5:
=IF(B8>0.35,"*","")

 

[K.S.Warrier]

I think it is N5=If(B8>0.35,"","*")
Thank you,

K.S.Warrier

 

[JulieD]

Hi randy

don't see why you need a macro ... and i can't see from your post what B10
has to do with anything, but here's a formula that checks the value of B8
and does the appropriate in N5
=IF(B8=0.35,"",IF(B8>0.35,"*","not sure"))
(also didn't know what you wanted to do if B8 was less than .35 ... replace
the "not sure" bit with what you want to see in N5 when B8 is less than .35)


Cheers
JulieD