ChrisKad
08-19-2015, 07:57 AM
Hi,
I'm put this formula in VBA:
Range("K3").Formula = "=IF(G3>$K$1,$K$1,G3)"
However, the result is that whether or not G3 is greater than K1, it just puts K1 all the way which falsifies all my results.
How can I modify my formula so that it calculates correctly?
Thanks a lot :)
I'm put this formula in VBA:
Range("K3").Formula = "=IF(G3>$K$1,$K$1,G3)"
However, the result is that whether or not G3 is greater than K1, it just puts K1 all the way which falsifies all my results.
How can I modify my formula so that it calculates correctly?
Thanks a lot :)