Results 1 to 3 of 3

Help on defining an Excel formula based on a special condition

Threaded View

  1. #1
    Registered User
    Join Date
    10-29-2019
    Location
    Berlin, Germany
    MS-Off Ver
    MS 365 64 Bit
    Posts
    13

    Help on defining an Excel formula based on a special condition

    Hi Team,

    I am in a bit of a fix with a formula I want to set up.

    The goal is to calculate the total meal allowance (column E).

    The intended formula is: Meal allowance rate (column B) * days in Germany (column C) * ((no of children)+1 if the number of days in Germany is more than zero).

    I am struggling to capture the last bit of the formula (...*((no of children)+1 if the number of days in Germany is more than zero). The plus 1 only happens as long as the value in column C is more than zero.

    Example is as shown in row 3 in my screenshot(Fred):

    6.41* 16 * (0+1) = 384.6 (Here I added 1 because the value in C3 is more than zero.

    Example in row 4 (Jane) is also seeing a +1 because even though the number of children is zero, the value in column C4 is more than zero.

    Hope my explanation is clear enough.

    Thanks in advance.

    Regards,

    Kay Bee
    Attached Files Attached Files
    Last edited by Kay Bee; 07-13-2020 at 01:17 PM. Reason: ensuring title fits what is needed

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. excel formula question
    By surin526 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2015, 09:12 PM
  2. Replies: 1
    Last Post: 03-04-2012, 12:03 AM
  3. Excel formula question
    By win386 in forum Excel General
    Replies: 3
    Last Post: 01-10-2009, 02:31 AM
  4. IF formula question:create a excel IF formula
    By Jonsby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2008, 07:12 AM
  5. Excel formula question
    By datalife in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2007, 01:46 PM
  6. excel formula question
    By k.vangeffen in forum Excel General
    Replies: 2
    Last Post: 01-17-2006, 03:00 PM
  7. Excel formula help/question
    By Jodi in forum Excel General
    Replies: 5
    Last Post: 06-14-2005, 11:05 PM

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