ExcelBanter - two formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - two formulas (https://www.excelbanter.com/excel-discussion-misc-queries/188381-two-formulas.html)

Kevin

two formulas

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

Kevin

two formulas

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

Kevin

two formulas

Never mind, I got it to work

"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

Bob I

two formulas

If you could, what would you expect the output to be, or look like?

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

Bob I

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

All times are GMT +1. The time now is 09:03 PM.