Thread: [Solved] Multiple IF
View Single Post
 
Old 08-01-2016, 06:11 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
  
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default
Is the third test 5000 (as in the first equation) or 50000 (as in the second). Anyhoo, this should work. Modify as needed.

Code:
=IF(K81<3000,K81*10%,IF(K81>=5000, K81*6%,K81*8%))
I only have Office 2010 so no IFS available.
Reply With Quote