Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-22-2014, 09:01 AM
micro44 micro44 is offline Microsoft Word IF statement issues Windows 7 32bit Microsoft Word IF statement issues Office 2013
Novice
Microsoft Word IF statement issues
 
Join Date: Oct 2014
Posts: 3
micro44 is on a distinguished road
Default Microsoft Word IF statement issues

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")))
Reply With Quote
 



Similar Threads
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
Microsoft Word IF statement issues Issues with Microsoft Word Form Fields 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft