Results 1 to 5 of 5

If statement

Threaded View

Guest If statement 05-01-2010, 11:43 PM
JBeaucaire Re: If statement 05-02-2010, 01:23 AM
Guest Re: If statement 05-02-2010, 02:23 AM
JBeaucaire Re: If statement 05-02-2010, 02:41 AM
Guest Re: If statement 05-02-2010, 03:24 AM
  1. #1
    ZIXILPLIX
    Guest

    If statement

    Assume cell A1 is a number to one decimal place but will never be negative. I need a code for cell B1 that will report the number in cell A1 with the text "FT" after it unless the number in A1 is 0 in which case B1 will report "N/A"

    So if A1 is "7.2" B1 will read "7.2FT" but if A1 is "0" B1 will read "N/A"

    Any help would be greatly appreciated.
    Last edited by ZIXILPLIX; 05-02-2010 at 03:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1