View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
cbgraphics cbgraphics is offline
external usenet poster
 
Posts: 4
Default IF formula for 3 possible conditions

Thank you as well!

" wrote:

Hello,

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

Regards,
Bernd