If statment problem

  • Thread starter Cerealkiller via OfficeKB.com
  • Start date
C

Cerealkiller via OfficeKB.com

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))))
 
C

Cerealkiller via OfficeKB.com

Don said:
=if(h44=0,o44,if(h44>0,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)
 
D

Don Guillett

Touching the space bar is NOT 0

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Cerealkiller via OfficeKB.com said:
Don said:
=if(h44=0,o44,if(h44>0,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)
 
D

Don Guillett

=IF(OR(LEN(TRIM(G44))<1,G44=0),H44,"whatever")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Don Guillett said:
Touching the space bar is NOT 0

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Cerealkiller via OfficeKB.com said:
Don said:
=if(h44=0,o44,if(h44>0,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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to get this if statment to work 2
Indirect function in Index/Match Array 5
=IF problem 5
For...Next loop problem!! 5
Calling Jim Cone - OFFSET Function 0
macro Help 3
MAcro help 0
Pasting problems 1

Top