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
Bookmarks