| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Make a negative response to if question equal zero
I have a excel doc which takes
B9 ($12,000) represents value of product B11 =sum(b9*.01) equals $1,200 B13 (125,000) represents mileage B15 =IF(B130,1-(B13/100000),1) B17 (25%) represents a modifier B25 SUM(B11*B15*B17) represents final solution of -$75.00 My problem is this when B13 is over 100,000 the result in B15 is negative which makes the final solution in B25 a negative number. If calculation in B25 is negative I would like it to return a value of zero. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
| Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| How do I make one cell equal to another | Excel Worksheet Functions | |||
Threaded Mode
