Write Excel formulas in VBA code

Hi Guys,

I am trying to write some formulas into a VBA code but as my begginner knowledge does not suffice, the result does not do the Job.
Here are the formulas:

=IF(COUNTIFS([Material];[@Material];[Werk];60)>0;TRUE();FALSE())
=IF(SUM(SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"L");SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"K")*(-1))>0;TRUE();FALSE())
=IFERROR(((SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"L")-SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"K"))/SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"L")*(100))<=50;FALSE())
=IF(ISBLANK([@Material]);"";IF(AND([@[Prüfung Werk 60]];[@[Prüfung Wert]]);"keine Fehler";IF(AND([@[Prüfung Werk 60]];[@[Prüfung Wert]]=FALSE());"Preis < Kosten";IF(AND([@[Prüfung Werk 60]]=FALSE();[@[Prüfung Wert]]);"W60 fehlt"; "W60 fehlt & Preis < Kosten"))))
=IF(SUM(SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"L");SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"K")*(-1))<0;SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"L")-SUMIFS([Preis aus IDoc];[Material];[@Material];[W];"K");"")

If you could give me a Hand with that it would be awesome ;-)

Many thanks!

exemple sheet with desired result would be a good start


Kind regards
Leo

Guys,

thank your for your replies.
I have enclosed the Excel file, the formulas that I am trying to write in the code are in columns J, K, L, M, N.

Many thanks again!

Norie,

thanks for your reply.
I am familiar with double quotes, I unfortunately cannot do the rest...