Hi all,
Please help to fix my formula below. I just want to be able to get the total fee when 2 conditions are met.
=IF(I7<=3,(E7*5),IF(I7<=12,(E7*14),IF(I7<=18,(E7*30),IF(I7<=36,(E7*40),IF(I7<=250,(E7*50),IF(I7>370,(E7*100)))))))*2
This formula works but I like to add another condition IF C and D column is not equal to ''APPLE" then multiple into 2 else multiple to 1.
thank you in advance.
Bookmarks