How make IF Formula return a numbers joined with a letter

		Microsoft Office Forums > Microsoft Word > Word
How make IF Formula return a numbers joined with a letter

FAQ

Thread Tools

Display Modes

#11

01-07-2019, 02:04 PM

macropod

Windows 7 64bit How make IF Formula return a numbers joined with a letter

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Quote:

Originally Posted by Strogg

The second code worked fine. I simply opened formula dialogue:
Layout-->Formula, then pasted your code there and all worked.
I just can't figure out how to add checking:
if A1 is empty, then show nothing..

For that you could use a formula coded as:
{IF{=A1}= 0 "" {=A1-250 \# "'33x26x20'; '39x26x25';'25x22x15'"}}

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I make a slide in PPT return to start page automatically?	sawe90	PowerPoint	1	09-15-2018 12:56 PM
make single letter top to bottom of page-Large	famreeks	Word	3	04-27-2017 05:40 PM
Substring to return numbers	funkyfido	Excel	4	07-22-2016 10:03 AM
How to make MATCH/INDEX formula return multiple successive responses.	danigirl121	Excel	7	06-08-2016 01:57 PM
Words joined - how do i split?	speaking	Word	4	08-29-2011 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:49 PM.