In my job estimation spreadsheet i want to have the option to enter a whole number or a decimal number in a given cell and have one single formula that will produce a cost. For example if i enter "20" in cell b4 or if i decide to enter "2.3" in the same cell b4 ( one or the other) the result in b5 will be the correct cost as multiplied be either the $60.00 hr or $1.00 min. I am looking for one single formula. I could not find the thread and wasn't sure how to word the search option. Thank you Roy
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
=if(b4 is a whole number, multiply by x,y)
- Thread starter RoyS
- Start date
