correct formula when cell is blank to leave blank

[rjmdc]

i protect my worksgheets when i add formulas before i give to the other staff
i add 100 blank rows to my tables to allow them to add data without VBA
when i add the formulas i get rows of NA instead of blank
please help me fix the formulas:
=XLOOKUP([@[CLIENT NAME]],brokers_cm[Participant],brokers_cm[tabs id],"NA") what do i do when client is blank
=[@[ LATEST SAP DATE]]+180 - how do i compute only when sap date is not blank
same for =DATEDIF([@[ LATEST SAP DATE]],TODAY(),"m") sap date is blank
same here =XLOOKUP([@[Tabs ID]],brokers_cm[tabs id],brokers_cm[Broker Name],"NA")

somehow i keep making errors when rows are blank

 

[Skybluekid]

try putting =IFNA("formula","")

 

[rjmdc]

it works for the na's
how do i fix this part
=[@[ LATEST SAP DATE]]+180
when latest sap date is blank i need a blank cell as a result

 

[Skybluekid]

=IF(ISBLANK(cell reference),"",formula) or IF(cell reference) = "","",formula

 

[rjmdc]

IF(cell reference) = "","",formula worked perfectly and i adjusted all the others to follow this pattern