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.