| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
create multiple formulas in 1 cell
I am trying to create a formula for rent purposes of a hotel.
I want the formula to add 7 days to the date for every $75, add 14 days for $150 etc. I know the basic formula eg =A4+7*(B4=75) But how do I make add the others also without multiplying the first ones? If I type in =A4+7*(B4=75) then try to type in the rest A4+14*(B4=150) It will only give me the true result of the last one and multiply the first HELP Please??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Multiple lines in 1 cell | Excel Discussion (Misc queries) | |||
| can i create multiple columns from the info in one cell | Excel Discussion (Misc queries) | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Threaded Mode
