Hi Friends,
i am using the below formula where i need to drag down this to end of the column , when i drag down this is hows NA as there is not value in Column C when correct value pops in C Column than only the result will show in a cell.
Requirements :
When i drag this down it should should blank if there is not Value in Column C.
Formula
=CONCATENATE(IF(C5="Already Billed To Secondary","None",IF(C5="Already Flipped","None",IF(C5="Already Worked","None",IF(C5="Amount Mismatch","GP As Per Eob The Patient Responsibility Not Matching With Erp-Hence Not Billing To Patient",IF(C5="Billed Patient","GP Flipped To Patient As This Is Patient Deductible",IF(C5="Billed Secondary","GP Billed Secondary Via Zirmed",IF(C5="Cannot Locate Eob","GP Eob Not Fnd On Zirmed & Healthlogic",IF(C5="Code Not Billed","GP Code Npot Billed",IF(C5="Credit Balance","None",IF(C5="Denial/Partial Denial","GP As Per Eob There Is No Patient Responsibility So No Need To Filp To Patient",IF(C5="Eob Not Found","GP EOB Not Fnd On Zirmed & Healthlogic",IF(C5="Fee Issue","GP Insurance Is Not Paying As Per ERP",IF(C5="Incorrect Fee","GP Insurance Is Not Paying As Per Erp ",IF(C5="Medicaid Secondary","GP As Per Eob Secondary Ins Is Medicaid",IF(C5="Medicare Crossover","GP Crossover Forwarded To",IF(C5="Need To Bill Via Hardcopy","GP Need To Bill Secondary Via Hardcopy",IF(C5="Payment Not Posted","GP Payment Not Posted Yet",IF(C5="Rejected By Zirmed","GP Billed Secondary But Rej By Zirmed",IF(C5="Zero Balance","None","NA")))))))))))))))))))," "," ",G5)
how do i add If(C2=""," " before the formula, Kindly help
Bookmarks