Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
Howdie,
My current if states IF(F56="","",(VLOOKUP(N56,$A$56:$E$200,5,0))) I now want to add the condition that if cell p56=10.1 then instead of doing the vlookup on N56, do it on P56. So Basically three condions 1)if F56 is blank, put blank 2)If F56 is not blank, then is P56 = "10.1"? If P56 is equal to 10.1, do do the Vlookup on P56, and if its not equal to 10.1 do the Vlookup on N56 Note Both conditions can not be true, ie P56 can not be 10.1 and f56 be blank at the same time. Range is always the same. Whats the new all encompassing IF ? :) Confusing..? hope not! *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
Hi Darin,
Try this :- =IF(F56="","",IF(P56=10.1,VLOOKUP(P56,$A$56:$E$200 ,5,0),VLOOKUP(N56,$A$5 6:$E$200,5,0))) All the Best. Paul From: Darin Kramer Howdie, My current if states IF(F56="","",(VLOOKUP(N56,$A$56:$E$200,5,0))) I now want to add the condition that if cell p56=10.1 then instead of doing the vlookup on N56, do it on P56. So Basically three condions 1)if F56 is blank, put blank 2)If F56 is not blank, then is P56 = "10.1"? If P56 is equal to 10.1, do do the Vlookup on P56, and if its not equal to 10.1 do the Vlookup on N56 Note Both conditions can not be true, ie P56 can not be 10.1 and f56 be blank at the same time. Range is always the same. Whats the new all encompassing IF ? :) Confusing..? hope not! *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
=IF(F56="","",if(P56=10.1,(VLOOKUP(P56,$A$56:$E$20 0,5,0)),(VLOOKUP(N56,$A
$56:$E$200,5,0)))) - Mangesh -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
Thanks, works perfectly Do you perhaps know how to say if cell A1 is text, then ignore, if its a number then multiply by 1. (I need to run only on numbers not on text that is within the sample..) *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
Hi Darin,
Try this ( Puts a BLANK if it is TEXT ) :- =IF(ISNUMBER(A1),A1,"") All the Best. Paul From: Darin Kramer Thanks, works perfectly Do you perhaps know how to say if cell A1 is text, then ignore, if its a number then multiply by 1. (I need to run only on numbers not on text that is within the sample..) *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If within an If...
Numbers only match numbers, so it is implicit if your lookup value is a
number. -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Thanks, works perfectly Do you perhaps know how to say if cell A1 is text, then ignore, if its a number then multiply by 1. (I need to run only on numbers not on text that is within the sample..) *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|