Thread: two formulas
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default two formulas

You need another closing parentheses.

Kevin wrote:

Correction

I want to use the first formula and have it do the same as the second
formula. So I would like to use =IF(A5<=TODAY(),MAX(SUM($F$4:F5)-50,0)


"Kevin" wrote:


Can I use two formulas in a cell? If so, how? I would like to use

=MAX(SUM($F$4:F5)-50,0) and =IF(A5<=TODAY(),J5+329.230769230769,"")

Thanks