| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default value for an excel formula
Hi,
I am trying to work out a way to set a default value for a cell if the value from a formula returned is too low. For example: I am using a very basic formula to calculate square metres from panel dimensions and the another formula to calculate the cost to paint these panels. Sometimes the panels are quite small and the value returned in the cost column becomes artificially low (even though the formula is working correctly the value shown will not cover my labour costs.) Therefore I need excel to look at the formulated value and if it is below, lets say 20, then it would automatically return a value of 20. Hoping someone can help me with this problem. Thank-you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default value for an excel formula
=IF(B2*D2<20,20,B2*D2) This may be of help... http://www.cpearson.com/excel/HintsA...roupUsers.aspx "Hints and Tips for New..." -- Jim Cone Portland, Oregon USA "Reg" wrote in message Hi, I am trying to work out a way to set a default value for a cell if the value from a formula returned is too low. For example: I am using a very basic formula to calculate square metres from panel dimensions and the another formula to calculate the cost to paint these panels. Sometimes the panels are quite small and the value returned in the cost column becomes artificially low (even though the formula is working correctly the value shown will not cover my labour costs.) Therefore I need excel to look at the formulated value and if it is below, lets say 20, then it would automatically return a value of 20. Hoping someone can help me with this problem. Thank-you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default value for an excel formula
You want the Max function, as in:
=Max(Yourformula,20) This will return the maximum of the two numbers. If the result of Yourformula is less than 20, Max will return 20. Regards, Fred. "Reg" wrote in message ... Hi, I am trying to work out a way to set a default value for a cell if the value from a formula returned is too low. For example: I am using a very basic formula to calculate square metres from panel dimensions and the another formula to calculate the cost to paint these panels. Sometimes the panels are quite small and the value returned in the cost column becomes artificially low (even though the formula is working correctly the value shown will not cover my labour costs.) Therefore I need excel to look at the formulated value and if it is below, lets say 20, then it would automatically return a value of 20. Hoping someone can help me with this problem. Thank-you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default value for an excel formula
Thank you, works perfectly and response was immediate.
Thanks again "Fred Smith" wrote: You want the Max function, as in: =Max(Yourformula,20) This will return the maximum of the two numbers. If the result of Yourformula is less than 20, Max will return 20. Regards, Fred. "Reg" wrote in message ... Hi, I am trying to work out a way to set a default value for a cell if the value from a formula returned is too low. For example: I am using a very basic formula to calculate square metres from panel dimensions and the another formula to calculate the cost to paint these panels. Sometimes the panels are quite small and the value returned in the cost column becomes artificially low (even though the formula is working correctly the value shown will not cover my labour costs.) Therefore I need excel to look at the formulated value and if it is below, lets say 20, then it would automatically return a value of 20. Hoping someone can help me with this problem. Thank-you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Default value for an excel formula
Glad I could help. Thanks for the feedback.
Regards, Fred "Reg" wrote in message ... Thank you, works perfectly and response was immediate. Thanks again "Fred Smith" wrote: You want the Max function, as in: =Max(Yourformula,20) This will return the maximum of the two numbers. If the result of Yourformula is less than 20, Max will return 20. Regards, Fred. "Reg" wrote in message ... Hi, I am trying to work out a way to set a default value for a cell if the value from a formula returned is too low. For example: I am using a very basic formula to calculate square metres from panel dimensions and the another formula to calculate the cost to paint these panels. Sometimes the panels are quite small and the value returned in the cost column becomes artificially low (even though the formula is working correctly the value shown will not cover my labour costs.) Therefore I need excel to look at the formulated value and if it is below, lets say 20, then it would automatically return a value of 20. Hoping someone can help me with this problem. Thank-you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I set a minimum(or default) value a a result from formula | Excel Discussion (Misc queries) | |||
| Default Windows Profile without default Office user info | Excel Discussion (Misc queries) | |||
| Default ribbon to open by default when opening xls in browser | Excel Discussion (Misc queries) | |||
| how do you get rid of default 0 in a cell that has a formula set u | Excel Discussion (Misc queries) | |||
| How to display = in the formula bar by default | Excel Discussion (Misc queries) | |||
Hybrid Mode
