View Single Post
  #1   Report Post  
SlipperyPete SlipperyPete is offline
Junior Member
 
Posts: 0
Default Multiple IF statements in WORD

Hello - really stuck on trying to figure something out at work that would make my life alot easier.

I have a simple one column table in a word doc with 6 rows. I have bookmarked it as "CET1"

I would like to have a formula/statement elsewhere in the word doc that is driven off of the SUM value of this table 6 row, 1 column table

IF SUM of CET1 2 then "Reject"
IF SUM of CET1 = 2 and 10 "Approve"
IF SUM of CET1 =10 and 50 "Escalate"
IF SUM of CET1 = 50 "Management"

Thanks!

Joe