3 Way Argument

[ExcelRoy]

Hi,

I have a 3 way argument that i need 3 different outcomes

IF Q146 =0 i need a "" returned
IF Q146 >0 i need the contents of cell Q146 to be shown
IF Q147 ="" then i need "-" shown

Thanks

 

[Desu Nota from Columbus]

Hi,

I have a 3 way argument that i need 3 different outcomes

IF Q146 =0 i need a "" returned
IF Q146 >0 i need the contents of cell Q146 to be shown
IF Q147 ="" then i need "-" shown

Thanks

What is currently in cell Q146? And you want Q146 to be "-" when Q147 is "" or was this a typo?

you can use an =IF statement:

=If(Q146=0,"",IF(Q146>0,Q146,IF(Q146="","-",IF(Q146="",""))))

 

[ExcelRoy]

I am currently working on 2000 but need to work on 2003 aswell

Thanks

 

[Rick Rothstein]

IF Q146 =0 i need a "" returned
IF Q146 >0 i need the contents of cell Q146 to be shown
IF Q147 ="" then i need "-" shown

Can the contents of Q146 ever be negative? If so, what should be displayed for it?

 

[Aladin Akyurek]

Hi,

I have a 3 way argument that i need 3 different outcomes

IF Q146 =0 i need a "" returned
IF Q146 >0 i need the contents of cell Q146 to be shown
IF Q147 ="" then i need "-" shown

Thanks

Q147? I'll assume you meant Q146...

=IF(Q147="","-",IF(N(Q146),Q146,""))

 

[ExcelRoy]

Can the contents of Q146 ever be negative? If so, what should be displayed for it?

They should never show a negative value

 

[Desu Nota from Columbus]

=If(Q146=0,"",IF(Q146>0,Q146,IF(Q147="","-",)))

 

[Rick Rothstein]

Give this formula a try...

=IF(Q147="","-",IF(Q146,Q146,""))

 

[ExcelRoy]

ok, so im getting myself a little confused here (not hard)

I need the following

IF Q146 =0 i need a "-" returned & IF Q146 >0 i need the contents of cell Q146 to be shown


IF Q147 ="" then i need "" shown

Hope i am not confusing you too much

Thanks

 

[Rick Rothstein]

Okay, then try this...

=IF(Q147="","",IF(Q146,Q146,"-"))