I NEED A FORMULA IN EXCEL?

Solved/Closed
Report
-
 Mafrin -
Hello,

Hello...
I have a cell A1 that show $200.00. now if am type $ 200.00 in B2 automatically A1 cell amount should show as 0
your help much appriciated

Mafrin

1 reply

Hi Mafrin,

Right click on sheet tab > View code and insert this code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B2") = "$200.00" Then Range("A1") = "0"
End Sub


Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Hello Trowa,

Its Great!!!

but i don't know how to run that code in work sheet. please advice

Best regards
Mafrin