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

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

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

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

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

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