Calculate 2% of colum H & column I & considered the greater number between them
column S should be positive, so don't considere the no. which are negative
& if column S is lower than that 2% of column H or Column I (whichever is greater )then put -1
vba macro will be placed in a seperate file , sheet name can be anything, all files are located in different place
example
the U2 cell will become -1 after runing the macro
Similar to this from MoldyBread at excelforum
https://www.excelforum.com/excel-pro...ml#post5338184
Reply With Quote
Bookmarks