logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

IF Formula for Copying Cell B4 with Numbers 1-10 Range: =IF(AND(B4>=1, B4

suavek 53249 6
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
Reply | New topic
  • #1 8178027
    suavek
    Level 2  
    Hello,

    I need to write an IF formula, which, provided there are numbers from 1 to 10 in cell B4, will copy the contents of cell B4.

    I think it should be something like:

    = IF (B4 = 1: 10, B4)

    but I do not know how to select this range from 1 to 10, because as it is in the example (1:10) it does not work ...

    Please help...
  • ADVERTISEMENT
  • #2 8178331
    walek33
    Level 29  
    In the logic test, use the formula AND () from the Polish language version.
  • ADVERTISEMENT
  • #3 8179284
    suavek
    Level 2  
    Ok, what if you wanted to do that with a two-cell value study? Ie. If cell A contains values from 1 to 10 and cell B contains "specific text", enter the value from cell a ??
  • ADVERTISEMENT
  • #4 8179452
    adamas_nt
    Moderator of Programming  
    Apply a colleague's advice:
    walek33 wrote:
    In the logic test, use the formula AND () from the Polish language version.
    This is just one more condition, so three in all ...
  • Helpful post
    #5 8185969
    aand
    Level 11  
    = IF (And (B4 = 0), B4,0)
    so I would check if the cell is from 0 to 10. The logical function I () in Excel is AND ()?

    And so with an extra cell containing specific text:
    = IF ((I (B4 = 0; B3 = "tralala")); B4,0)
  • Helpful post
    #6 8186091
    adamas_nt
    Moderator of Programming  
    suavek wrote:
    Ok, what if you wanted to do that with a two-cell value study? Ie. If cell A contains values from 1 to 10 and cell B contains "specific text", enter the value from cell a ??
    Then in "Excel", for data in one line, according to your formula
    Code: text Expand Select all Copy to clipboard
    =JEŻELI(ORAZ(A40;B4="tralala");A4;0)
  • ADVERTISEMENT
  • #7 8198143
    suavek
    Level 2  
    Ok, it works - thanks a lot
Reply | New topic
Report a violation of the law

Topic summary

The discussion revolves around creating an IF formula in Excel to copy the value from cell B4 if it falls within the range of 1 to 10. The initial formula proposed by the user was incorrect, as it attempted to use a range notation that Excel does not support. Responses included suggestions to use the AND function to check if B4 is between 1 and 10. A more complex scenario was introduced, where the user wanted to check if another cell (A) contained values from 1 to 10 while cell B contained specific text. The final solution provided was a combination of the IF and AND functions to achieve the desired outcome.
Summary generated by the language model.
ADVERTISEMENT