Dear all,
Hope I can explain this clearly:
If Cell E has a figure and Cell F is empty Cell H should return a number BUT if Cell E + Cell F are larger then 200 cell H shall return "do not supply"
Excel Snapshot.PNG
I have the below formula, however they seem to be conflicting with one another.
=IFERROR(IF(E222=200,"250",IF(E222=250,"200",IF(SUM(F222+E222)=0,"250",IF(SUM(E222+F222)<200,IF(E222>=250,MAX(0*SUM(250-E222),0),"200"),"do not supply")))),0)
Thank you and regards
Bookmarks