Today i have been struggling to get a "If,if.if formula, which i had goten to work (The first part, before i realized that I forgot to take the currency in to account).
Working:
I thought this was an easy fix by making this formula:
However it says I've put in to many arguments, which confuses me, does that mean a nested formula can't have this many functions?
I want my formula to look in which currency it should be (EUR / USD) (so that it can grab the right price .
Afterward it needs to look what kind of work was done (displayed in cell :Project!C23)
- Working hours
- travel time
- waiting time
When it knows that it should get the right values (EUR: prijs! I13:I15), (USD: J13:J15)
So basically i would really appreciate if someone could tell me how/if i can fix this issue!
Thanks in advance
Bookmarks