| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statment problem
=if(h44=0,o44,if(h440,n44,"whatever")) -- Don Guillett Microsoft MVP Excel SalesAid Software "Cerealkiller via OfficeKB.com" <u59737@uwe wrote in message news:a8b088e35664e@uwe... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF, AND statment | Excel Worksheet Functions | |||
| IF Statment | Excel Discussion (Misc queries) | |||
| Help with If statment | Excel Discussion (Misc queries) | |||
| If statment if its possible. | Excel Discussion (Misc queries) | |||
| If statment | Excel Worksheet Functions | |||
Linear Mode
