 • 511K Members
• 4,690 Online
• 608K Conversations
SOLVED

# joining seperate formula into 1 cell

Hi all

I have 3 separate formula's that work individually and wish to join them into 1 cell. how is this done correctly? these are the 3 separate formula:

=IF(F15=0,0,IF(F15=1,0.1,IF(F15<=15,-0.0027*(F15)^2+0.0719*(F15)+0.1098)))

=IF(15<F15<=300,0.2337*(F15)^0.345,IF(15<F15,0.2337*(F15)^0.345))

=IF(300<F15<= 5000,0.0589*(F15)^0.5897,IF(300<F15,0.0589*(F15)^0.5897))

I want it to look something like this, so it assess the cell with the 3 variable options ie 15 or less, 300 or less, over 300:

=IF(F15=0,0,IF(F15=1,0.1,IF(F15<=15,-0.0027*(F15)^2+0.0719*(F15)+0.1098))) ? IF(15<F15<=300,0.2337*(F15)^0.345,IF(15<F15,0.2337*(F15)^0.345)) ? IF(300<F15<= 5000,0.0589*(F15)^0.5897,IF(300<F15,0.0589*(F15)^0.5897))

3 Replies
Solution

# Re: joining seperate formula into 1 cell

That could be like

```=IF(F15=1, 0.1,
IF(F15>300,
0.0589*(F15)^0.5897,
IF(F15 > 15,
0.2337*(F15)^0.345,
-0.0027*(F15)^2+0.0719*(F15)+0.1098)))*
(F15<>0)```

# Re: joining seperate formula into 1 cell

absolutely brilliant, that works..

many thanks, much appreciated.

# Re: joining seperate formula into 1 cell

@Alphawolf1 , you are welcome

Related Conversations
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Bitlocker keys not visible in Active Directory
Anez1987 in Windows 10 management on
1 Replies