| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF statement problem
doing a spreadsheet in which I have an IF statement that compares two numbers.. for example C11=1500 while E77=e76(2058)-c77(558) which equals 1500 as well but when I make an IF statement that looks like =IF(E77C11,"A","B") I keep getting a result of an A when 1500 is obviously not greater than 1500.. when I manually put "1500" in cell e77 the IF statement works correctly.. does it have to do with having a function in Cell E77? -- webstju ------------------------------------------------------------------------ webstju's Profile: http://www.excelforum.com/member.php...o&userid=33703 View this thread: http://www.excelforum.com/showthread...hreadid=534833 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I'm having a really strange problem with 3 if statements. | Excel Worksheet Functions | |||
| If Statement linked to cell with VLOOKUP problem - getting wrong v | Excel Worksheet Functions | |||
| Fundamental problem with IF statement | Excel Worksheet Functions | |||
| Formula Problem - If Statement | Excel Worksheet Functions | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
Threaded Mode
