Help with Multiple Conditions formula

gidget424

New Member
Joined
Nov 22, 2005
Messages
10
I am working on a spreadsheet and need a formula in a single cell with multiple conditions in it. Here are the 2 scenarious I need:

IF(B40="X",IF(S9="x",0),""))
OR
IF(B40="x",IF(S9="",E40*D40),"")

Thanks!!! :confused:
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Maybe:

=IF(UPPER(B40)="X",IF(S9="x",0,IF(S9="",E40*D40,"")),"")

Edit: Tiny change in formula
 

Watch MrExcel Video

Forum statistics

Threads
1,118,065
Messages
5,569,985
Members
412,301
Latest member
excelmaps
Top