Thread: If Statement returns true when false?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
  
Posts: 1,670
Default If Statement returns true when false?
Here is the formula I am using
G21=5188
G22=10
G24=.12
G28=5188
G29-1556
=IF(G28<G22=SUM(G28:G29),G24*(G22-G21),IF(G22<G21,0,G29*G24))

Why does the statement start false and turn true? If it starts false
shouldn't it stay false no matter what the rest of the logical test says? So
what kind of logical test do i need to write so that if either part is false
then the statement is false?

Reply With QuoteReply With Quote