You are here: HomeExcelTutorials

# Multiple functions in one cell

## Multiple functions in one cell

Price: FREE

Is there a way to write a formula that will leave a cell blank if a specified value is a positive number, but will calculate a percentage if the value is a negative number? I know how to write these formulas separately, but cannot seem to get it right bringing them together in one cell. Not sure if this is even possible.

Visit publisher's web-site: Multiple functions in one cell

Category and Tags: ExcelTutorials : : Functions

## Related Tutorials

### Using multiple IF, AND, VLOOKUP functions

Free: Yes
Tags: Excel ›

I have multiple columns and each cell in that particular column has further option of selecting a value from a Drop down list. Based on the values in the cells and combining it with cell value in other cells, I want to publish the final status which is fixed.i have tried using multiple IF and AND function but no success.Would request you to please help.Excel is attached here for reference.Sample Excel Problem.xls

### Multiple Functions of a Cell

Free: Yes
Tags: Excel ›

I'm trying to use this spread sheet for purchasing fuel and to subtract the fuel tax from the pump price when I purchase fuel so if I type in cell B2 IL I want \$0.43 to show up in Cell C2 but. If I type IN in cell B2 I want \$0.16 to show up in Cell C2 and so on for all the States I buy fuel in =IF(C2="IL",0.43,0) if I type this in Cell C2 that is good for IL but I can't seem to do a multiple =IF in the same Cell

### Multiple IF Statement

Free: Yes
Tags: Excel › Functions

I am trying to make a cell produce a value baed on the current value entered in a cell.
i.e. Cell A2 can have 4 possible numbers 1,2,3,4
Cell A1 should be either 20%, 40%, 60%, 80% depending on the
number selected 1 = 20% etc
How would I use a formula in cell A1 to produce this requirement. A multiple IF Statement possibly?

### multiple math functions

Free: Yes
Tags: Excel ›

I am trying to multiple one cell by a set number and then I need to have the result rounded to the nearest tens. If the number ends with a 4 or less I need it to round to the lower tens. Example 8654, I need to have rounded to 8650. Also, if the number ends in a 5 or above I need it to round to the next highest tens. I have multiple rows to do this with so I was thinking of a if then statement but can't figure it out.

### multiple Hyperlinks one Excel cell?

Free: Yes
Tags: Excel › Functions

Is it possible to enter multiple links in one Excel cell? I am using the function string rather than the GUI interface.

## Related Applications & Scripts

### Assign multiple shortcuts and events to a function

Free: No
Tags: JavaScript › Excel jQuery

Assign is a jQuery utility plug-in that lets you easily assign multiple keyboard shortcuts and events for specified functions.

### PHP Contact Form - Multiple E-Mail

Free: No
Tags: Flash › Excel Emailing Forms

PHP Contact Form, Multiple E-Mail. Flash PHP contact form XML driven, which means you can easily edit settings like company name, emails, description.

### Multiple Distance & Direction Calculator

Free: No
Tags: JavaScript › Excel Calculators

Calculate Distance between Multiple Locations at once using Google MAP API .
Features :
1. Easy to integrate
2. Supports Multiple Locations (more than 2 locations)
3. Auto generate addresses into Textbox when typed
4. Uses Google Ajax call, so no Page load is required
5. Added JQuery to make the code more easy to integrate
6. Smaller layout, so that we can use it as widget.
7. Only HTML & Javascript knowledge required

### Image Wheel - Multiple Image Uploader

Free: No
Tags: PHP › Excel Upload Systems

Multiple image uploader that is easy to install and use. The demo only allows to upload images smaller than 200kb. Please note that the images in our demo have been uploaded by viewers and may contain nudity or disturbing images.
If you like our updates then please consider re-purchasing the item.

### Grid Gallery

Free: No
Tags: Flash › Excel Image Galleries

The Grid Gallery UnLtd is a multiple gallery image viewer and slideshow presentation. It has multiple functions and is very easy to set up. Just follow all the instructions in the extensive help file which will guide you through the whole process form start to finish setting up your very own Grid Gallery.