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:
 

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
 

Forum statistics

Threads
1,077,868
Messages
5,336,861
Members
399,109
Latest member
gdcuk

Some videos you may like

This Week's Hot Topics

Top