Prev: Decimal/Percentage to Whole Number
Next: updating two seperate spreadsheets with same info
From: Cerealkiller via OfficeKB.com on 28 May 2010 13:51
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.aspx/ms-excel/201005/1

From: Don Guillett on 28 May 2010 13:57

=if(h44=0,o44,if(h44>0,n44,"whatever"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Cerealkiller via OfficeKB.com" <u59737(a)uwe> wrote in message
news:a8b088e35664e(a)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.aspx/ms-excel/201005/1
>

From: Cerealkiller via OfficeKB.com on 28 May 2010 14:22
Don Guillett wrote:
>=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))))


Thank you that worked perfectally.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1

From: Cerealkiller via OfficeKB.com on 28 May 2010 14:51
Don Guillett wrote:
>=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)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1

From: Don Guillett on 28 May 2010 15:21
Touching the space bar is NOT 0

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Cerealkiller via OfficeKB.com" <u59737(a)uwe> wrote in message
news:a8b10ed6426b5(a)uwe...
> Don Guillett wrote:
>>=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)
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1
>

 |  Next  |  Last
Pages: 1 2
Prev: Decimal/Percentage to Whole Number
Next: updating two seperate spreadsheets with same info