Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula needed
I have the following columns.
Svgs Fee Total 1 $25.00 $15.00 $15.00 2 $25.00 $0.00 $25.00 I need to be able to tell Total to either put the svgs value or the fee value but not both. If we collect a fee we can not charge for the svgs we created. If that makes since I would sure appreciate your help on this. Thank you in advanced. |
#2
|
|||
|
|||
Admiral70 wrote...
.... I need to be able to tell Total to either put the svgs value or the fee value but not both. If we collect a fee we can not charge for the svgs we created. .... =IF(Fee,Fee,Savings) |
#3
|
|||
|
|||
Thanks for such a quick response. I think that will work, I noticed if
the Fee is a negative number it thoughs it off. I will just have to tell them to not enter negative numbers there. Thanks |
#4
|
|||
|
|||
Admiral70 wrote...
Thanks for such a quick response. I think that will work, I noticed if the Fee is a negative number it thoughs it off. I will just have to tell them to not enter negative numbers there. If you want the savings when fees are negative, use =IF(Fee0,Fee,Savings) |
#5
|
|||
|
|||
After I see it and use it, it makes so much since. This should be
Excel 101 but could not find it anywhere. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula needed | Excel Discussion (Misc queries) | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions |