If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
If statment problem
I have Excel 2000 I am trying to make this IF statement work. What I want to
do is if H44 equals a number 1 to whatever then use colum N44 if H44 equals 0 then use O44 =IF(H44=0,0,IF(OR(H44=N44,IF(OR(H44=O44)))) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
#3
|
|||
|
|||
If statment problem
Don Guillett wrote:
=if(h44=0,o44,if(h440,n44,"whatever")) I have Excel 2000 I am trying to make this IF statement work. What I want to [quoted text clipped - 3 lines] =IF(H44=0,0,IF(OR(H44=N44,IF(OR(H44=O44)))) Thank you that worked perfectally. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
#4
|
|||
|
|||
If statment problem
Don Guillett wrote:
=if(h44=0,o44,if(h440,n44,"whatever")) I have Excel 2000 I am trying to make this IF statement work. What I want to [quoted text clipped - 3 lines] =IF(H44=0,0,IF(OR(H44=N44,IF(OR(H44=O44)))) another quick formula If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
#5
|
|||
|
|||
If statment problem
Touching the space bar is NOT 0
-- Don Guillett Microsoft MVP Excel SalesAid Software "Cerealkiller via OfficeKB.com" u59737@uwe wrote in message news:a8b10ed6426b5@uwe... Don Guillett wrote: =if(h44=0,o44,if(h440,n44,"whatever")) I have Excel 2000 I am trying to make this IF statement work. What I want to [quoted text clipped - 3 lines] =IF(H44=0,0,IF(OR(H44=N44,IF(OR(H44=O44)))) another quick formula If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
#6
|
|||
|
|||
If statment problem
=IF(OR(LEN(TRIM(G44))1,G44=0),H44,"whatever")
-- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... Touching the space bar is NOT 0 -- Don Guillett Microsoft MVP Excel SalesAid Software "Cerealkiller via OfficeKB.com" u59737@uwe wrote in message news:a8b10ed6426b5@uwe... Don Guillett wrote: =if(h44=0,o44,if(h440,n44,"whatever")) I have Excel 2000 I am trying to make this IF statement work. What I want to [quoted text clipped - 3 lines] =IF(H44=0,0,IF(OR(H44=N44,IF(OR(H44=O44)))) another quick formula If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
Thread Tools | |
Display Modes | |
|
|