Results 1 to 16 of 16

Thread: [RESOLVED] Problem Comparing Range Values

Hybrid View

  1. Sep 20th, 2005, 01:56 PM #1
    Botillier
    Botillier is offline

    Thread Starter
    Member
    Join Date
    Aug 2005
    Posts
    61

    Re: Problem Comparing Range Values

    Thank you for your idea I am relatively new to vb so could you please give me an example of how and when I would multiply the value by a hundred and then how and when I would revert it by dividing by a hundred.
    Reply With Quote Reply With Quote
  2. Sep 20th, 2005, 02:19 PM #2
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Problem Comparing Range Values

    In the line

    VB Code:
    1. If CellB + CellC = CellA_

    put

    VB Code:
    1. If (Fix(100*CellB)/100) + (Fix(100*CellC)/100)= (Fix(100*CellA)/100) _

    HTH

    zaza
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width