|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 28th, 2010, 08:18 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
If statment
If g44 equals 0 then h44 it is returning it as false maybe i am missing
something =IF(G44=0,H44) -- Message posted via http://www.officekb.com 
|
|
#2
May 28th, 2010, 08:29 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statment
What happens if G44 0?
=IF(G44=0,H44,"Criteria not met") -- Best Regards, Luke M "Cerealkiller via OfficeKB.com" u59737@uwe wrote in message news:a8b14b1d7b679@uwe... If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) -- Message posted via http://www.officekb.com
|
|
#3
May 28th, 2010, 08:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statment
Luke M wrote:
What happens if G44 0? =IF(G44=0,H44,"Criteria not met") If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) If G44 is I do nto want it to do anything I want a 0 in the cell so maybe If g44 equals 0 then h44 if g44 is then 0 I am not sure if that make sense -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1
|
|
#4
May 28th, 2010, 08:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statment
=IF(G44=0,H44,0)
-- Best Regards, Luke M "Cerealkiller via OfficeKB.com" u59737@uwe wrote in message news:a8b17939cf7a4@uwe... Luke M wrote: What happens if G44 0? =IF(G44=0,H44,"Criteria not met") If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) If G44 is I do nto want it to do anything I want a 0 in the cell so maybe If g44 equals 0 then h44 if g44 is then 0 I am not sure if that make sense -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1
|
|
#5
May 28th, 2010, 09:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statment
=IF(G44=0,H44) returns H44 value if G4 is 0
Are you sure g44 is 0 or just formatted to show whole number? Maybe value is 0.0000000012 or similar? What happens when you use this formula? =IF(G44=0,H44,"not zero") Gord Dibben MS Excel MVP On Fri, 28 May 2010 19:18:00 GMT, "Cerealkiller via OfficeKB.com" u59737@uwe wrote: If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44)
|
|
#6
May 28th, 2010, 10:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statment
Gord Dibben wrote:
=IF(G44=0,H44) returns H44 value if G4 is 0 Are you sure g44 is 0 or just formatted to show whole number? Maybe value is 0.0000000012 or similar? What happens when you use this formula? =IF(G44=0,H44,"not zero") Gord Dibben MS Excel MVP If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) Thank you the value was wrong. I thought I had the formula right but sometimes you just need and outside look. Thank you againe now it works. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
