ExcelBanter - how do you combine a drop-down list with an IF function in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do you combine a drop-down list with an IF function in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/185448-how-do-you-combine-drop-down-list-if-function-excel.html)

Jolina Kiew

how do you combine a drop-down list with an IF function in Excel

see subject line

Gord Dibben

how do you combine a drop-down list with an IF function in Excel

Not enough detail in subject line...............please describe in body of your
next posting.

Or maybe.......assuming A1 dropdown list value is one of several items.

=IF(A1="item1",do if true, do if false) entered in B1

Gord Dibben MS Excel MVP

On Mon, 28 Apr 2008 20:15:00 -0700, Jolina Kiew <Jolina
wrote:

see subject line

All times are GMT +1. The time now is 12:43 PM.