Macros replace if arguments

**Bakar** · 02-19-2012, 11:12 AM

Hi Everybody
Actually I would like to write a macro using VBA to
give me example
Cell B2 must give me the result of different cells as a condition (using if_and arguments is getting so many
Example as follow
Cell B2 must give me result in cell B4 if it is above zero
and if cell B4 is zero and cell B5 > 0 must give the result of B5
if cellB5 is zero and B6 > 0 must give the result of B6 ....... up to cell B18

Thanks

Bakar

**gjlindn** · 02-19-2012, 11:58 AM

Hello Bakar. In your data set if B7 > 0 would B4:B6 all be equal to 0? It would be easier to solve this if I were clear on what happens to your data in range B4:B18. I'm wondering if you need a macro or a formula something like

Please Login or Register  to view this content.

If you can provide an example workbook that would help. Thanks!

**Bakar** · 02-19-2012, 12:55 PM

Hi gjlindh
Hope everything going well
Find attached screenshot
Actually I want the result of Y25 to display in cell Y17

fORUM.jpg

Macros replace if arguments

LinkBack

Thread Tools

Rate This Thread

Display

Macros replace if arguments

Re: Macros replace if arguments

Re: Macros replace if arguments

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions