Consulting

Results 1 to 2 of 2

Thread: regarding IF commands into VBA

  1. #1

    regarding IF commands into VBA

    Hi,

    Is there a possibility to make a VBA with this?

    =IF((A1+B2)>255,(A1+B2)-256,A1+B2) 
    = IF((A2+B3)>255,(A2+B3)-256,A2+B3) 
    = A3
    Last edited by strikermail; 08-12-2010 at 02:46 PM.

  2. #2
    VBAX Mentor
    Joined
    Dec 2008
    Posts
    404
    Location
    eg[VBA]Sub AAA()
    '=IF((A1+B2)>255,(A1+B2)-256,A1+B2)
    If [A1] + [B2] > 255 Then
    MsgBox [A1] + [B2] - 256
    Else
    MsgBox [A1] + [B2]
    End If

    End Sub[/VBA]

    Artik

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •