Hello.
I am trying to formulate an IF Condition with multiplication. If column A = XYZ, then multiply column B by ###.
Solved! Go to Solution.
this is what tried:
IF [Billing Report Category]= "Net Enhanced Return Funds billed at 32.0bp"
THEN [Ending GAAP Book Value]*.0008
ENDIF
From first glance it looks like you are missing the ELSE component of the IF statement. So just drop in ‘ELSE [Ending GAAP Book Value]=Null()’ right after the THEN portion and leave the ENDIF as is. If you are still having problems, be sure to check your data types.
I'm having a similar issue with my If statement. I'm trying to create a formula if it's [FG] then *30% and if [BG] then*40%.
I keep getting an "operator must be between operands" error. Not sure why the = is flagged in the image below.