MrExcel Publishing
Your One Stop for Excel Tips & Solutions

False Return no value ??


Posted by Michael Saunders on March 07, 2001 6:10 AM

I have a value in a cell A1 thats 10, I only want that value of 10 to change if B3=30 but if B3 doesnt equal 30 then don't change the value in A1


any Ideas ?


Posted by Mark W. on March 07, 2001 6:17 AM

Enter the formula, =IF(B3=30,30,10), into cell A1.

Posted by Michael Saunders on March 07, 2001 6:21 AM

Thanks for your reply

The problem is the value in A1 10 will always be different... so I never know what that value will be. so I need something that will look for a match, if the match is found, paste it. If not leave the previous value

Thanks again

Posted by Mark W. on March 07, 2001 6:23 AM

Then you'll need a custom VBA function.