Hi,
I seem to have some more trouble with a long nested IF formula and got great help here the last time.
The problem is as follows:
=IF(E8=Data!I8;(L8-O8)*0,02+(O8*0,2);IF(E8=Data!G8;O8*0,4;IF(E8=Data!H8;O8*0,2;IF(E8=Data!J8;(L8-O8)*0,02+(O8*0,2);""))))
I currently have the formula above which calculates based on choices in a dropdown list in E8. What i want to do is to simply add another criteria for it to run the entire sequence via a second dropdown list in F8 - Basically "If "JA"(Yes in norwegian" is chosen in F8 run the formula above, if not do nothing or return a zero.
I thought this would be easy enough, however i keep returning an error.
Would greatly appreciate if someone could have a look
(PS this is a google sheet)
Bookmarks