Forum Discussion

Mattafact's avatar
Mattafact
Copper Contributor
Jan 25, 2025

=IF Formula Woes

Hello All! I'm working on a spreadsheet with a cell (C2) containing a drop-down menu.  I'm trying to create a formula in another cell (D2) dependent on the selected item in the drop-down menu.  I w...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 28, 2025

As variant

=IF( $C$1="14 Day", 14,
 IF( $C$1="21 Day", 21, NA() ) )
 *B2*C2

or slightly modified for legacy Excel HansVogelaar formula

=LEFT($C$1,2)*B2*C2

Resources