# Help on defining an Excel formula based on a special condition

1. ## 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.

Regards,

Kay Bee

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