Hi all,
Is anyone assist me using vba code with below formulars?
p15=IF(H15="","",TRUNC(L15*N15,0))
p15=IF(H15="","",TRUNC(IF(R15>AC15,AC15,0),0))
p15=IF(H15="","",TRUNC(R15*$H$8,0))
p15=IF(H15="","",TRUNC(ROUND(X15,-2),0))
because of such formulars are p15:p5000, the excel speed is so slow, that is why I want to use vba code instead of the above formulars.
Thanks in advance
Bookmarks