Adam Bede

    IF + Concatenation

    image

    If + ISNUMBER + ISTEXT

    image

    You can quickly format numbers in Excel using the following keyboard shortcuts:

    • General format: Ctrl + Shift + ~
    • Currency format: Ctrl + Shift + $
    • Percentage format: Ctrl + Shift + %
    • Scientific format: Ctrl + Shift + ^
    • Date format: Ctrl + Shift + #
    image
    image
    image
    image