![]() |
#1
|
|||
|
|||
![]()
Hi! I have looked all over for an answer to this so I apologize if it has been answered elsewhere.
I am trying to create a nested if statement in a Word table based on a drop down box in one of the table's cells. Cell B2: Drop box (High, Medium, Low) Cell B3: Any numerical value (We can use 100 for the example) Cell B4: If formula I have (successfully!) created this formula in excel, but I can't seem to get it right in Word. Instead of posting my terrible attempts in Word I have included the Excel formula below. Could someone please help me with the proper Word formula??? =IF(B2="High",B3/(1+B3*0.2^2),IF(B2="Medium",B3/(1+B3*0.1^2),IF(B2="Low",B6/(1+B6*0.05^2),"FALSE"))) |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft office 2010 professional plus 64 bit launching issues | kmg | Office | 1 | 11-16-2013 05:56 AM |
Help with IF statement in word 2010 | Mad | Word | 2 | 04-06-2013 06:31 AM |
Combining Multiple Word Documents Heading/Figure Issues Word 2007 | grantgibson45 | Word | 1 | 09-10-2012 11:00 PM |
![]() |
hbforsyth | Word | 9 | 11-14-2011 04:26 PM |
Issues with synchronization log causing send/receive issues | WinSock64 | Outlook | 0 | 01-11-2011 11:29 AM |