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

 

[ExcelRoy]

Sorry Rick, maybe one more try here as i am not getting my intended result

Lets try

IF everywhere in H15:H138 shows "" then return ""
IF Q146 shows 0 then return "-"
IF Q146 shows >0 then return Q146

Many thanks for all your help

 

[Rick Rothstein]

H15:H138... where did that come from? A suggestion for future questions you may ask... do not try to simplify them for us... all that will get you are solutions for a question you do not actually care about and, as you can see, they will not always be easily modifiable by you for your actual setup. See if this formula works...

=IF(COUNTBLANK(H15:H138)=124,"",IF(Q146,Q146,"-"))

 

[ExcelRoy]

Apologies Rick, this almost works, but doesn't show Q146 if its value is >0

Thanks for all your help

 

[ExcelRoy]

Edit: Sorted

Thanks for your help Rick

 

[Rick Rothstein]

Apologies Rick, this almost works, but doesn't show Q146 if its value is >0

Edit: Sorted

Just for clarity sake, I tested the formula before I posted it and it worked as it was supposed to; that is, the value of Q146 was displayed when that cell contained a value greater than 0. I'm assuming the "Sorted" comment refered to a typo or something on your end.

 

[ExcelRoy]

Hi Rick, the formula was perfect, i just changed it from

=IF(COUNTBLANK(H15:H138)=124,"",IF(Q146,Q146,"-"))

changed it to

=IF(COUNTBLANK(H15:H138)=124,"",IF(Q146=0,"-",Q146))

Works a dream!

Thanks