U Ufoo Member Oct 25, 2018 #1 Hello excel gurus, please help me with the problem in the attached excel sheet. Thanks Attachments If challenge.xlsx 19.9 KB · Views: 11
V vletm Excel Ninja Oct 25, 2018 #2 Ufoo modify cell F6 like =H$3*(H5-IF(H5>=1000,INT(H5/1000)*500,H$2)) and copy down
U Ufoo Member Oct 25, 2018 #3 vletm said: Ufoo modify cell F6 like =H$3*(H5-IF(H5>=1000,INT(H5/1000)*500,H$2)) and copy down Click to expand... Thanks a lot. It works perfectly
vletm said: Ufoo modify cell F6 like =H$3*(H5-IF(H5>=1000,INT(H5/1000)*500,H$2)) and copy down Click to expand... Thanks a lot. It works perfectly
