two formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 21 May 2008 19:20 GMT

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

Reply to this Message

Kevin - 21 May 2008 19:25 GMT

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)

> 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

Reply to this Message

Bob I - 21 May 2008 19:31 GMT

You need another closing parentheses.

> Correction
>
[quoted text clipped - 6 lines]
>>
>>Thanks

Reply to this Message

Kevin - 21 May 2008 19:27 GMT

Never mind, I got it to work

> 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

Reply to this Message

Bob I - 21 May 2008 19:28 GMT

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

> 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

Reply to this Message