Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel - Multiple actions for each part of IF statement?

 1 Week Ago #1 goshenBleeping Windows 7 Home Premium 64bit 13 posts Excel - Multiple actions for each part of IF statement? How would I accomplish the following in Excel 2010: IF (A=B, (action 1 & action 2), action 3) If A=B, execute both action 1 & action 2. If A not equal B, execute action 3. Thank you. My System Specs
 .
 1 Week Ago #2 Paul Black 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3 3,020 posts Planet Earth VGhlIFgtRmlsZXM= Hi goshenBleeping,    Quote: Originally Posted by goshenBleeping How would I accomplish the following in Excel 2010: IF (A=B, (action 1 & action 2), action 3) If A=B, execute both action 1 & action 2. If A not equal B, execute action 3. Without an example of the parameters etc, you should be able to get an idea from this => =IF(A1=A2,(A1*2+A1*3),"x") I hope this helps! My System Specs
 1 Week Ago #3 goshenBleeping Windows 7 Home Premium 64bit 13 posts Clearly I did a poor job of explaining my problem. None of the statements below work. Can someone suggest the correct syntax? I want to do the following: =IF(A1=2, B3=27, B3=4) ==> this sets cell B3=27 if cell A1=2, else sets cell B3=4: HOW to do this? Also =IF(A1=2, B3=27 & B4=16, B3=4) ==> this sets cells B3 and B4 if cell A1 = 2, else set cell B3=4: HOW to do this? My System Specs
 .
 1 Week Ago #4 Paul Black 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3 3,020 posts Planet Earth VGhlIFgtRmlsZXM= Hi goshenBleeping,    Quote: Originally Posted by goshenBleeping I want to do the following: =IF(A1=2, B3=27, B3=4) ==> this sets cell B3=27 if cell A1=2, else sets cell B3=4: HOW to do this? =IF(A1=0,"No Figure In A1",IF(A1=2,27,4)) I hope this helps! My System Specs
 1 Week Ago #5 Paul Black 7 HP SP1 64-bit Vista HB SP2 32-bit Linux Mint 18.3 3,020 posts Planet Earth VGhlIFgtRmlsZXM= Hi goshenBleeping,    Quote: Originally Posted by goshenBleeping Also =IF(A1=2, B3=27 & B4=16, B3=4) ==> this sets cells B3 and B4 if cell A1 = 2, else set cell B3=4: HOW to do this? Seeing you are using a formula in cell B3, you cannot adjust cell B3 using another formula because it will give you a circular error! Your best bet in this situation would be to use a helper column. I hope this helps! My System Specs

Excel - Multiple actions for each part of IF statement?

 Similar help and support threads Thread Forum excel if statementwe are wanting to see if we can create an if statement in excel. basically, we are looking to create an if statement. in the first picture below, you see we have a "3" under quanity. then you also see the prices as well. we're wanting to do something like this - if "A5" (the quanity) is greater... Microsoft Office Multiple actions on power buttonHello, I would like to both log off and hibernate when I press the power button, but Control panel permits only one action. Ideally, I'd like to configure the windows"start" button to do the same. Have you any idea how i could configure my computer to do so? Thanks for your help. Lionel General Discussion Irreversible actions in Excel 2010Hello, For reversing an action, e.g., getting a text in a cell bold, In MS Excel 2010, we simply press ctrl+z or click undo button in the quick access toolbar. It seems that any action is reversible this way! If not, so what actions aren't reversible in Excel? Microsoft Office BSOD while playing online game and doing multiple actionsAlright a client based mmorpg game knightonline were open and i was doing my regular things. The BSOD happened. Gathered with BlueScreenView Here the result ================================================== Filename : hal.dll Address In Stack : hal.dll+12a3b From Address ... BSOD Help and Support Excel 2003 - Multiple Excel OpenHi All, I don't know if I'm posting in the right area but I really need help. Before (In XP and Vista), when I have one excel file open and I go to desktop to open a different excel, it would open in the same excel program (2 files in 1 program) With Windows 7, when I open a different file, it... Microsoft Office

 Our Sites Site Links About Us Find Us Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp. © Designer Media Ltd All times are GMT -5. The time now is 03:13.