Forum Discussion

ray963's avatar
ray963
Copper Contributor
Jun 20, 2025

Formula Required if possible

Hi All,

 

Can the following be accomplished…

 

Help with a formula….

 

Sheet1 C8 and Sheet2 F7

 

Three alternative texts to choose from….

 

Sheet1 C8 – text entered “CASH” then Sheet2 F7 shows “CASH”.

 

OR

 

Sheet1 C8 – text entered “NIL” then Sheet2 F7 shows “NO PAYMENT”.

 

OR

 

Sheet1 C8 – text entered “EFT” then Sheet2 F7 shows “ELECTRONIC FUNDS TRANSFER (EFT)”

excel
Formulas and Functions

3 Replies

Sort By
  • ray963's avatar
    ray963
    Copper Contributor
    Jun 22, 2025

    Hi SnowMan55,

     

    Can't get formula right to show outcome in Sheet2 F7

     

    Sheet1 C8 – text entered “CASH” then Sheet2 F7 shows “CASH”.

     

    What am I doing wrong?

     

  • SnowMan55's avatar
    SnowMan55
    Bronze Contributor
    Jun 20, 2025

    You could use nested IF functions, but that's messy.

    If those are the only three values you will ever find in C8, I suggest the IFS function:

    =IFS(Sheet1!C8 = "CASH", "CASH",
     Sheet1!C8 = "NIL", "NO PAYMENT",
     Sheet1!C8 = "EFT", "ELECTRONIC FUNDS TRANSFER (EFT)",
     Sheet1!C8 = "", "",
     TRUE, "[something else]"
)

    (The extra spaces and line breaks (Alt+Enter) are completely optional.  I include them for ease of reading.)

    The comparison of Sheet1!C8 to an empty string is my presumption on what you want, as is the last Boolean test (TRUE, which covers all other possibilities).

    Of course, if you might have other valid values in C8 in the future, it would be best to put a cell range or Excel table with those valid values and their counterparts somewhere, and use the XLOOKUP function to do the translation.

Resources