View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default IF formula for 3 possible conditions

Hello,

Another approach:
=CHOOSE((V71000)+(V7200)+(V70),V7+16,V7*1.08,V7 +80)

Regards,
Bernd