Results 1 to 3 of 3

how to have 2 mathemical functions based on text value of a cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-17-2009
    Location
    Torquay, England
    MS-Off Ver
    Excel 2013
    Posts
    253

    how to have 2 mathemical functions based on text value of a cell

    Hi,

    I'm putting together a table which shows monthly costs versus Total costs.

    Is there a way I could use if two choose between two option dependent on the value of cell A1.

    Example

    A1 = "Totals", multiply Subtotal in A13 by 12.

    A1 = anyother value multiply by 1.

    Something like:-
    =if(a1="totals",(a13*12), =if(a1<>""sum(a13*1)

    Any help much appreciated
    Last edited by Gooford; 11-10-2009 at 11:38 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