Prev: Decimal/Percentage to Whole Number
Next: updating two seperate spreadsheets with same info
From: Don Guillett on 28 May 2010 15:39
=IF(OR(LEN(TRIM(G44))<1,G44=0),H44,"whatever")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Don Guillett" <dguillett1(a)gmail.com> wrote in message
news:%23$083rp$KHA.4652(a)TK2MSFTNGP06.phx.gbl...
> 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
>>
>

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