| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Import Text | Excel Discussion (Misc queries) | |||
| Please Help Me with Custom menus | Excel Worksheet Functions | |||
| Stop renaming or moving sheet tabs | Excel Discussion (Misc queries) | |||
| Removing Rows for Printing | Excel Worksheet Functions | |||
| Help: runtime error - Method seriescollection object_chart failed | Charts and Charting in Excel | |||
Threaded Mode
