+ Reply to Thread
Results 1 to 2 of 2

how do I write a formula that will help !

  1. 12-29-2011, 01:43 PM #1
    cplape
    cplape is offline
    Registered User
    Join Date
    12-29-2011
    Location
    Kennebunk, Maine
    MS-Off Ver
    Excel 2010
    Posts
    5

    how do I write a formula that will help !

    If D1>F1 M1=D1 + 10% if D1<F1 M1 = F1 + 10%
    Reply With QuoteRegister To Reply
  2. 12-29-2011, 02:19 PM #2
    tigeravatar
    tigeravatar is offline
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: how do I write a formula that will help !

    Give this a try:
    =1.1*MAX(D1,F1)
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1