Results 1 to 6 of 6

assistance using text and forumula

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    assistance using text and forumula

    hi

    i am trying to add some text in to a calculation however i cant seem to figure it out.

    basically i have the cell to check 1 cell against another cell for a value. if it fails the requirements then i want the output to be (x1)@(x2)
    where
    x1 = (number from cell)
    @ = Text
    x2 = (number-(number*number))

    so far i have this

    =IF(F2>=B2,(C2-E2),IF(B2>D2,"",(C2-(A2*B2))))


    for the last false statment (in bold) i want it to read (B2)@(C2-(A2*B2)

    does that make sense?
    Last edited by twiggywales; 02-09-2012 at 08:13 AM.

Thread Information

Users Browsing this Thread

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

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