| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CREATE FORMULA IN EXCEL
I have items in a drop menu in D8 from a list in C29-C39. If the value of D8
= C29 then H14 (formula location) = D29 I have tried multiple versions of the below to no avail. =IF(D8=C29,D29,IF(D8=C30,D30,IF(D8=C31,D31,IF(D8=C 32,D32,IF(D8=C33,D33,IF(D8=C34,D34,IF(D8=C35,D35,I F(D8=C36,D36,IF(D8=C37,D37,IF(D8=C38,D38,IF(D8=C39 ,IF(D39,D8=C40,"")))))) Thanks for any help!! fyrefox |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i create a formula in excel | Excel Worksheet Functions | |||
| how to create a formula in excel | Excel Discussion (Misc queries) | |||
| create an excel formula with contitions | Excel Worksheet Functions | |||
| Create a formula in Excel? | Excel Worksheet Functions | |||
| How to create a formula in Excel | Excel Worksheet Functions | |||
Threaded Mode
