two formulas

K

Kevin

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
 
K

Kevin

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

Bob I

You need another closing parentheses.
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)


:
Click to expand...
 
Top