J
jeff
Hi,
If the recommended value is in B5, and the user can
input his/her value in B7, then use
=if(B7="",Calc*B5,Calc*B7)
jeff
different types of equipment required to be purchased
based on different forecasted volumes. The spreadsheet
calculates a recommendation, and then the user will have
the option to override the recommendation by typing in
their own recommendation. I need to create an if
statement that specifies that if the user has typed in
their own recommended number of units to buy, then the
sheet will use this number instead of the calculated
recommendation.
If the recommended value is in B5, and the user can
input his/her value in B7, then use
=if(B7="",Calc*B5,Calc*B7)
jeff
statement. The spreadsheet calculates the quantity of
different types of equipment required to be purchased
based on different forecasted volumes. The spreadsheet
calculates a recommendation, and then the user will have
the option to override the recommendation by typing in
their own recommendation. I need to create an if
statement that specifies that if the user has typed in
their own recommended number of units to buy, then the
sheet will use this number instead of the calculated
recommendation.