IF function

[freebee]

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.

 

[Mike H]

Hi,

I'm not sure what you mean by 'Value If True" but maybe this

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

Mike

 

[Max]

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

 

[Jarek Kujawa]

or

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

 

[freebee]

Hi, I tried, but cell showed i5+e6-j56. My complete formula
is=IF(N83>2008-8-1,l5+e6-j56," not finalized") My N83 is set to today().
thanks.

 

[Jarek Kujawa]

try:

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

 

[Max]

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]

Hi, thanks so much, both "date(2008,8,1)" and --"2008-8-1" mathod worked.

 

[Max]

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

 

[David Biddulph]

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(N83>DATE(2008,8,1),l5+e6-j56," not finalized")
or (less rigorously)
=IF(N83>--"2008-8-1",l5+e6-j56," not finalized")

 

[mona]

for Example If I want to check if A1=B1
=if(A1=B1,L5+E6-J56,"")