Thanks:  0
Likes:  0

# Thread: Multiple Formulas in same Cell

1. ## Re: Multiple Formulas in same Cell

If I follow, try:

Code:
`=IF(A2<40,0,A2-40)`
You'd have got a quicker response opening a new thread though.

Matty

2. ## Re: Multiple Formulas in same Cell

Dear,
I have faced a problem that, I make a invoice in five parts If i mark in description cell automatic show Sr NO Rate but Rate Cell is Show "False". But i want to stop if Description is no product name/marked Rate Cell would show Blank " "
Have any solution for me
 SR NO DESCRIPTION Rate Quantity AMOUNT 1 2 Chicken Spicy Wings(500Gm) 210 5 1050 3 Chicken Nuggets (1000Gm) 315 5 1575 4 Chicken Nuggets (1000Gm) 315 5 1575 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0 FALSE 0

3. ## Re: Multiple Formulas in same Cell

Welcome to MrExcel.

Although you have a similar problem to the one mentioned in this thread, it's always best to start a new thread rather than adding your question to an old one. That said, it sounds as though you need to wrap your existing formula within the IF function. Something like:

Code:
`=IF(A2="","",YourExistingFormulaHere)`
Where A2 contains the SR Number.

Matty

4. ## Re: Multiple Formulas in same Cell

Originally Posted by Anne Troy
Multiple CONDITIONS, yes. Multiple formulas, no.

For instance:

=IF(OR(A1>0,A1<25),"Yes","No")

will return Yes if A1 is between zero and 25, and No if it is zero or less than zero, or greater than 25.

How would you apply this same principle to return text based on TODAY date cell - i.e. if 2 weeks before TODAY return "xxx" and today/future date return "xxx" and if older than 2 weeks return "xxx"? Thanks

5. ## Re: Multiple Formulas in same Cell

I have multiple cells which have formulas in below

Cell

AW - =DAY(DATE(YEAR(L2),MONTH(L2)+1,0))
AX- =DATE(YEAR(L2),MONTH(L2)+1,0)-L2+1
AY - =EOMONTH(L2,0)
AZ - =DAY(DATE(YEAR(M2),MONTH(M2)+1,0))
BA - =EOMONTH(M2,0)
BB - =BA2-M2
BC - =AZ2-BB2
BD - =IF(BB2= 0,0,X2/AZ2*BC2)
BE - =DATEDIF(L2,M2,"m")+IF(AND(EOMONTH(M2,0)=M2,DAY(L2)>DAY(M2)),1,0)
BF - =X2*BE2
BG - =X2/AW2*AX2
BH - =BG2+BF2+BD2
BI - =IF(W2=0,"0",O2-BH2)

The final result is in cell BI and i have resorted to hiding them at the moment but is there any chance of getting all of this in one cell?

Any help would be appreciated

6. ## Re: Multiple Formulas in same Cell

Here are the two formulas that I want together

1 - =IF((D6=0,"",D6)
2 - =(DATE(YEAR(D6),MONTH(D6),DAY(D6)+21))

As you can see, dates are entered in D6 and +21 days are added to that date in another cell, but I don't want the silly 1900-01-21 to appear in that other cell when D6 is blank.... Both formulas work on their own but how do I combine them?

Thanks in advance (:

7. ## Re: Multiple Formulas in same Cell

Hi,

Try it like this:

=IF(D6=0,"",D6+21)

Format formula cell as Date.

8. ## Re: Multiple Formulas in same Cell

It does not work because its a date, the formula to add 21 days is (DATE(YEAR(D6),MONTH(D6),DAY(D6)+21))

do you think I could enter that instead of the D6+21?

Thanks for your help (:

9. ## Re: Multiple Formulas in same Cell

It Does work, have you tried it? Again format formula cell as Date:

D
110/25/2018
2
3
4
5
610/4/2018

Sheet310

Worksheet Formulas
CellFormula
D1=IF(D6=0,"",D6+21)

The Only way it Won't work is if the Date in D6 is Not a real date, but Text.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•