nmccracken12
New Member
- Joined
- Oct 8, 2020
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
I need help with a massive formula. I will do my best to explain this and please let me know if you need any more information.
IF AE2 ="DI" AND AC = ~list below with formulas to add~ Then use AF2 to calculate laid in OR if AE2 = ~any other value~ THEN run this formula =IF(ISNUMBER(AJ2),(AH2*AJ2)+SUM(AI2,AL2)-(AK2),IF(ISBLANK(AJ2),SUM(AG2,AI2)-(AK2),""))
Spirits --- (T2*U2)/1000*0.264172)*((AB2*2)*13.5)+B23
Sparkling Wine --- (T2*U2)/1000*0.264172)*B17+(T2*U2)/1000*C17+B23
Wine<16.5 --- (T2*U2)/1000*0.264172)*B15+(T2*U2)/1000*C15+B23
Wine>16.5 --- (T2*U2)/1000*0.264172)*B15+(T2*U2)/1000*C15+B23
IF AE2 ="DI" AND AC = ~list below with formulas to add~ Then use AF2 to calculate laid in OR if AE2 = ~any other value~ THEN run this formula =IF(ISNUMBER(AJ2),(AH2*AJ2)+SUM(AI2,AL2)-(AK2),IF(ISBLANK(AJ2),SUM(AG2,AI2)-(AK2),""))
Spirits --- (T2*U2)/1000*0.264172)*((AB2*2)*13.5)+B23
Sparkling Wine --- (T2*U2)/1000*0.264172)*B17+(T2*U2)/1000*C17+B23
Wine<16.5 --- (T2*U2)/1000*0.264172)*B15+(T2*U2)/1000*C15+B23
Wine>16.5 --- (T2*U2)/1000*0.264172)*B15+(T2*U2)/1000*C15+B23