Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with logical functions
I am Working with Excel 2003 using the IF operator where the correct result
appears but the value doesn't make sense to me. Using the following: =IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of 10,000,000*.07 which is 700,000 the result is correctly the number zero (0). The trouble is if I attempt to use that cell for additional calculations the value (0) is greater than any positive number. What am I missing? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with logical functions
Remove the quotations ,"0" and use 0 instead, you made the zero into text
and text is seen as greater than any numbers -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "beyond22" wrote in message ... I am Working with Excel 2003 using the IF operator where the correct result appears but the value doesn't make sense to me. Using the following: =IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of 10,000,000*.07 which is 700,000 the result is correctly the number zero (0). The trouble is if I attempt to use that cell for additional calculations the value (0) is greater than any positive number. What am I missing? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with logical functions
=IF(C9<F9,"0",C9-F9)
Remove the quotes " " from around the 0. =IF(C9<F9,0,C9-F9) Enclosing numbers in quotes makes them TEXT. TEXT will always evaluate to be greater than ANY number. "0" 1,000,000,000,000,000,000,000 = TRUE Biff "beyond22" wrote in message ... I am Working with Excel 2003 using the IF operator where the correct result appears but the value doesn't make sense to me. Using the following: =IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of 10,000,000*.07 which is 700,000 the result is correctly the number zero (0). The trouble is if I attempt to use that cell for additional calculations the value (0) is greater than any positive number. What am I missing? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with logical functions
You're entering 0 as text. Try eliminating the quotation marks around it.
-- Brevity is the soul of wit. "beyond22" wrote: I am Working with Excel 2003 using the IF operator where the correct result appears but the value doesn't make sense to me. Using the following: =IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of 10,000,000*.07 which is 700,000 the result is correctly the number zero (0). The trouble is if I attempt to use that cell for additional calculations the value (0) is greater than any positive number. What am I missing? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with logical functions
Dave F, many thanks. So simple, so powerful.
Beyond22 "Dave F" wrote: You're entering 0 as text. Try eliminating the quotation marks around it. -- Brevity is the soul of wit. "beyond22" wrote: I am Working with Excel 2003 using the IF operator where the correct result appears but the value doesn't make sense to me. Using the following: =IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of 10,000,000*.07 which is 700,000 the result is correctly the number zero (0). The trouble is if I attempt to use that cell for additional calculations the value (0) is greater than any positive number. What am I missing? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Working with logical functions
=IF(C9<F9,"0",C9-F9)
Maybe an alternative if you prefer: =MAX(C9-F9,0) -- Dana DeLouis "beyond22" wrote in message ... Dave F, many thanks. So simple, so powerful. Beyond22 "Dave F" wrote: You're entering 0 as text. Try eliminating the quotation marks around it. -- Brevity is the soul of wit. "beyond22" wrote: I am Working with Excel 2003 using the IF operator where the correct result appears but the value doesn't make sense to me. Using the following: =IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of 10,000,000*.07 which is 700,000 the result is correctly the number zero (0). The trouble is if I attempt to use that cell for additional calculations the value (0) is greater than any positive number. What am I missing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Functions in Excel | Excel Worksheet Functions | |||
working with time functions | Excel Discussion (Misc queries) | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions |