If statement and multiplication

[erikamedina]

Hello.

I am trying to formulate an IF Condition with multiplication.  If column A = XYZ, then multiply column B by ###.

[erikamedina]

this is what tried:

IF [Billing Report Category]= "Net Enhanced Return Funds billed at 32.0bp"
THEN [Ending GAAP Book Value]*.0008
ENDIF

[bmcclelland46 · Accepted solution]

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.

[jjimenez]

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.