| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the final "result" to show in one cell? Excell 2002
Hello, I am soooo confused with this scenario....
I have checkboxes set up. cell H8 has: 1st checkbox formula is: =IF(D8=TRUE,60,"") cell I8 has: 2nd checkbox formula is: =IF(E8=TRUE,120,"") I would like the final result to show up in H8. For example: If D8 was checked off - I would like the result to show up in H8. If E8 was checked off - I would like the result to show up in H8 too. How is this accomplished? Right now I have 2 total columns BUT I would only like one Please help! Thanks in advance! Lisa Ann |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
| Show a blank result in a cell when there is no value in the "Lookup" cell | New Users to Excel | |||
| Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro | Excel Discussion (Misc queries) | |||
| Why does excell switch my stock symbol "ACN" to "CAN"? | Setting up and Configuration of Excel | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
Threaded Mode
