Thread
:
Calculations
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Calculations
I did this using several variations so you can see that there is more than
one way to skin the cat.
sub doit()
if range("a1")+cells(2,1)=cells(3,"a") then
msgbox "OK"
else
msgbox "not ok"
end if
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ryan W" wrote in message
...
In MS Access I was able to do
if A + B = C then
do action
else
do another action
end if
Can I do the same in Excel for example:
if Cell.A1 + Cell.A2 = Cell.A3 then
What would the VBA look like?
Thank you for your time,
Ryan
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett