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
IF + Concatenation