LinkBack URL
About LinkBacks
If the number is 80 (or less) than it is 20,000 and for every 80 (or less) after that it is another 20,000 . I have a list of numbers from 10 up to 2000. How would I do that?
If the number is 80 (or less) than it is 20,000 and for every 80 (or less) after that it is another 20,000 . I have a list of numbers from 10 up to 2000. How would I do that?
Please read forum rules below about titles.
Your question isn't very clear either.
If you want to return the 20,000 in another column use
and drag down=IF(A1<80,20000,"")
If you need just a sum try
VBA Noob=COUNTIF(A:A,"<80")*20000
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks