Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Function not working
The first and second IF functions are working, but not the third:
=IF(B1<B2,C1*.005,IF(B1=B2,C1*.01,IF(B1=B3,C1*.0 12))) I assume it has something to do with the = but I don't know another way. Thank you. |
#2
|
|||
|
|||
There is no indication on what action should be taken if B1<B3, the False
condition http://HelpExcel.com "sonicj" wrote: The first and second IF functions are working, but not the third: =IF(B1<B2,C1*.005,IF(B1=B2,C1*.01,IF(B1=B3,C1*.0 12))) I assume it has something to do with the = but I don't know another way. Thank you. |
#3
|
|||
|
|||
sonicj wrote:
The first and second IF functions are working, but not the third: =IF(B1<B2,C1*.005,IF(B1=B2,C1*.01,IF(B1=B3,C1*.0 12))) I assume it has something to do with the = but I don't know another way. Thank you. As I understand the logic of your expression it can never get to the third branch (which seems to be what you're experiencing). 1) if B1 < B2, THEN Case1 2) If B1 = B2 THEN Case2 3) Can't ever get to Case3. ALL cases will be trapped by 1 or 2. If you understand K Maps for logic design, apply one to your equations and it will leap right off the paper at you. Perhaps you intended: = IF(B1<B2,C1*.005,IF(B1=B3,C1*.012,C1*.01)) Good luck... Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function in xl2003 not working in xl97 | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
Maskerr function not working on my new computer - help? | Excel Worksheet Functions | |||
Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |