| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF function
Hi, I'd like to know how to set a formula in "value if true". I want to get
sum of L5+e6-J56 when the value is true Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Hi,
I'm not sure what you mean by 'Value If True" but maybe this =IF(A1=1,L5+E6-J56,"") Mike "freebee" wrote: Hi, I'd like to know how to set a formula in "value if true". I want to get sum of L5+e6-J56 when the value is true Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
An example, in say F6: =IF(A1="x",L5+E6-J56,"")
The IF checks that if A1 contains "x" then the calculation: L5+E6-J56 will proceed, otherwise just return a blank: "" -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "freebee" wrote: Hi, I'd like to know how to set a formula in "value if true". I want to get sum of L5+e6-J56 when the value is true Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
or
=IF(A1,L5+E6-J56,"") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Hi, I tried, but cell showed i5+e6-j56. My complete formula
is=IF(N832008-8-1,l5+e6-j56," not finalized") My N83 is set to today(). thanks. "Max" wrote: An example, in say F6: =IF(A1="x",L5+E6-J56,"") The IF checks that if A1 contains "x" then the calculation: L5+E6-J56 will proceed, otherwise just return a blank: "" -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "freebee" wrote: Hi, I'd like to know how to set a formula in "value if true". I want to get sum of L5+e6-J56 when the value is true Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
try:
=IF(N83DATE(2008,8,1),l5+e6-j56," not finalized") |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Try it as: =IF(N83 --"2008-8-1",L5+E6-J56," not finalized")
--"2008-8-1" will resolve the text (2008-8-1) to a real date for evaluation -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "freebee" wrote: Hi, I tried, but cell showed i5+e6-j56. My complete formula is=IF(N832008-8-1,l5+e6-j56," not finalized") My N83 is set to today(). thanks. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
Hi, thanks so much, both "date(2008,8,1)" and --"2008-8-1" mathod worked.
"Max" wrote: Try it as: =IF(N83 --"2008-8-1",L5+E6-J56," not finalized") --"2008-8-1" will resolve the text (2008-8-1) to a real date for evaluation -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "freebee" wrote: Hi, I tried, but cell showed i5+e6-j56. My complete formula is=IF(N832008-8-1,l5+e6-j56," not finalized") My N83 is set to today(). thanks. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
"freebee" wrote:
Hi, thanks so much, both "date(2008,8,1)" and --"2008-8-1" mathod worked. Welcome. Do take a moment to press the "Yes" buttons in both responses which helped, won't you. -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
2008 minus 8 minus 1 gives a result of 1999
If N83 is set to TODAY(), that will be 39644, as Excel stores dates as number of days from the beginning of 1900 (or 1904 if that option is chosen). 39644 is greater than 1999, so your IF test is satisfied. If you want to compare a date in N83 with 1st Auguust 2008, try =IF(N83DATE(2008,8,1),l5+e6-j56," not finalized") or (less rigorously) =IF(N83--"2008-8-1",l5+e6-j56," not finalized") -- David Biddulph "freebee" wrote in message ... Hi, I tried, but cell showed i5+e6-j56. My complete formula is=IF(N832008-8-1,l5+e6-j56," not finalized") My N83 is set to today(). thanks. "Max" wrote: An example, in say F6: =IF(A1="x",L5+E6-J56,"") The IF checks that if A1 contains "x" then the calculation: L5+E6-J56 will proceed, otherwise just return a blank: "" -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- "freebee" wrote: Hi, I'd like to know how to set a formula in "value if true". I want to get sum of L5+e6-J56 when the value is true Thanks. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF function
for Example If I want to check if A1=B1
=if(A1=B1,L5+E6-J56,"") "freebee" wrote: Hi, I'd like to know how to set a formula in "value if true". I want to get sum of L5+e6-J56 when the value is true Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
