Multiple Formulas in same Cell

gymwrecker

Active Member
Joined
Apr 24, 2002
Messages
390
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Is there a way to use multiple formulas for just one cell without damaging the others?

Thanks!
 
If I follow, try:

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

Matty
 
Upvote 0

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
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 NODESCRIPTIONRateQuantityAMOUNT
1
2Chicken Spicy Wings(500Gm)21051050
3Chicken Nuggets (1000Gm)31551575
4Chicken Nuggets (1000Gm)31551575
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0
FALSE0

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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:)
 
Upvote 0
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 :)
 
Upvote 0
Hi,

Try it like this:

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

Format formula cell as Date.
 
Upvote 0
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 :)
 
Upvote 0
It Does work, have you tried it? Again format formula cell as Date:


Book1
D
110/25/2018
2
3
4
5
610/4/2018
Sheet310
Cell Formulas
RangeFormula
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.
 
Upvote 0

Forum statistics

Threads
1,212,933
Messages
6,110,751
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top