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.

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.

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.

IF function
 

or

=IF(A1,L5+E6-J56,"")

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.

IF function
 

try:

=IF(N83DATE(2008,8,1),l5+e6-j56," not finalized")

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.

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.

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
---

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.

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.