Trying to create and IF formula where there is sometimes nothing to calculate against (just want "" to return) and other times where the calculation varies between currency and percentages. Think I'm close because I've avoided FALSE returns when I segment certain areas of the formula but not when I try to make everything work. Simple example of what I'm trying to do is attached. TIA!
Bookmarks