Forum Discussion

gminii's avatar
gminii
Copper Contributor
May 16, 2020

IF, SUMIF or SUMIFS help

Hi all

 

If column A has text (any text), then the value in column B is the same as a specific cell in column B, otherwise leave cell empty.

 

Any ideas? 🙂

 

Thank you!

💖

excel
Formulas and Functions

1 Reply

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 16, 2020

    gminii Your question is rather vague, but suppose the specific cell in B is B100, the following formula will look for the type of content in A1. Anything other than a text will return a blank, otherwise it returns whatever is in B100.

    =IF(ISNONTEXT(A1),"",$B$100)

     If this is complete nonsense to you, please clarify your needs.

Resources