Forum Discussion
aayushman_mishra
Aug 14, 2019Copper Contributor
FORMULAS
I HAVE TO SPLIT G6 INTO D6 AND E6 I.E -600 AND -150 RESPECTIVELY , PLEASE HELP ME. FILE ATTACHED
PReagan
Aug 14, 2019Bronze Contributor
Hello aayushman_mishra,
How is it determined that -600 goes into cell D6 and -150 goes into cell E6?
- aayushman_mishraAug 15, 2019Copper Contributor
PReagan hI, as per condition the discount amt not taken is -600 and the fine lies between -1 to -200 and re adm fee is -500. thats why we have to fix this formula.