Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, And
Can someone help me out with a fairly simple formula? I want a message to pop up saying " Please fill in the price". The function needs to say, If C100, and F10=0 then please fill in the price. It should be a simple function, but IF AND statements lose me!! -- M3Cobb ------------------------------------------------------------------------ M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986 View this thread: http://www.excelforum.com/showthread...hreadid=389005 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, And
One way:
If Range("C10").Value 10 And Range("F10").Value = 0 Then _ MsgBox "Please fill in the price" In article , M3Cobb wrote: Can someone help me out with a fairly simple formula? I want a message to pop up saying " Please fill in the price". The function needs to say, If C100, and F10=0 then please fill in the price. It should be a simple function, but IF AND statements lose me!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, And
If ((Range("C10").Value 0) And (Range("F10").Value=0)) Then _
MsgBox "Please fill in the price" The trickiest part of Ifs with Ands, Ors, or a combination of them is to make sure the conditions get put in the right order to be executed properly. For example: If A=1 And B=2 Or C=3 Does this mean: If (A=1 And (B=2 Or C=3)) Or does it mean: If ((A=1 And B=2) Or C=3) Or, worse, if there are Boolean variables or Variants involved, does it mean If (((A=1) And B)=2) Or C) = 3 That is why I like using the brackets, even if they are redundant - it helps me make sure the code is correct and helps me to see my intention if I go back to debug the code later. -- - K Dales "M3Cobb" wrote: Can someone help me out with a fairly simple formula? I want a message to pop up saying " Please fill in the price". The function needs to say, If C100, and F10=0 then please fill in the price. It should be a simple function, but IF AND statements lose me!! -- M3Cobb ------------------------------------------------------------------------ M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986 View this thread: http://www.excelforum.com/showthread...hreadid=389005 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, And
I would do it by putting the Cell values into variables and testing their
condition, something like this: Range("C10").Select A=ActiveCell Range("F10").Select B=ActiveCell If A0 And B=0 Then MsgBox ("Enter Data In Cell F10") End If This would obviously need expanding with some validation of the datafor the cells, but I think you should get the general idea. HTH Neil www.nwarwick.co.uk "M3Cobb" wrote: Can someone help me out with a fairly simple formula? I want a message to pop up saying " Please fill in the price". The function needs to say, If C100, and F10=0 then please fill in the price. It should be a simple function, but IF AND statements lose me!! -- M3Cobb ------------------------------------------------------------------------ M3Cobb's Profile: http://www.excelforum.com/member.php...o&userid=24986 View this thread: http://www.excelforum.com/showthread...hreadid=389005 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|