View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default VBA IF THEN with an OR

This link seems pretty decent:
http://www.experiglot.com/2006/12/11...th-and-or-not/

Look at this example:
=IF(OR(B6<$B$2,B6=$B$3),€¯No bonus€¯, B6*$B$1)
(it's a few clicks down the page...)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Papa Jonah" wrote:

I would like to have an IF Then statement that is of the ilk, If this or that
then...
How do I put the "or" part of it in there? I know how to do the or(x,y)
thing in a worksheet.
Thanks,
Papa J