Thread: IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.