IF(NOT(ISBLANK & IF(ISBLANK - Getting #INCORRECT for one part of the formula

Sam Lugiano

Hi,

I am only getting the correct answer for the first part of this formula. The second part IF(NOT(ISBLANK...is giving me an #INCORRECT ARGUMENT SET.

I would like to populate the "PROJECTED FEE" column with the number in "PROJECTED FEE - NO REFERRAL" if "Firm Fee" cell is blank, and if "Firm Fee" is not blank then the "PROJECTED FEE" cell should be blank

=IF([Firm Fee]@row = "", [PROJECTED FEE - NO REFERRAL]@row - [Referral Fee Amount]@row, IF(NOT(ISBLANK([Firm Fee]@row = ""))))

Hope that makes sense. Thanks

Sam

Sam Lugiano

Quick edit. I left one thing out.

I would like to populate the "PROJECTED FEE" column with the difference between "PROJECTED FEE - NO REFERRAL" - "Referral Fee Amount" (if there is one), if "Firm Fee" cell is blank.

L_123

=IF([Firm Fee]@row = "", [PROJECTED FEE - NO REFERRAL]@row - [Referral Fee Amount]@row,"")

Give that a try

Sam Lugiano

Thank you!