Hi guys.
I'm a bit new in VBA coding, but have worked with Excel a lot.
I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables.
My formula right now is: =IF(AND(Z29>0;AA29>0;AB29>0);C4;IF(AND(Z29>0;AA29>0);C5;IF(AND(Z29>0);C6;IF(H29=$C$25;C6;IF(H29=$C$25-$D$5;C5;IF(H29=$C$25-$D$4;C4;""))))))
The cell marked as "Claim Date" is a =Timestamp() if that's important to know.
Are any of you, able to help me, solve this? Maybe with a VBA code? So I am able to determine the variables myself?
Best regards Daniel
I'm a bit new in VBA coding, but have worked with Excel a lot.
I have this Claim sheet I am working on. And I need the Claim Importance to show (Low, Medium, High) on multiple variables.
My formula right now is: =IF(AND(Z29>0;AA29>0;AB29>0);C4;IF(AND(Z29>0;AA29>0);C5;IF(AND(Z29>0);C6;IF(H29=$C$25;C6;IF(H29=$C$25-$D$5;C5;IF(H29=$C$25-$D$4;C4;""))))))
The cell marked as "Claim Date" is a =Timestamp() if that's important to know.
Are any of you, able to help me, solve this? Maybe with a VBA code? So I am able to determine the variables myself?
Best regards Daniel
