Hi,
Using Microsoft Excel 2007, I'm trying to apply different formulas to different numbers (1 to 7 days) but all "in the same cell'. Each day is worth $17.
For example: Each person earns $17 per day (=$120 per week). However 17 multiply by 7 = 119
The closest I've come as follows: =J10*17+IF(J10>"7"*17.1428571428,J10>7*17.1428571428,J10<6*17)
However the above for some reson "rounds-up" when days 1-6 are selected (7 is perfect)? 6 multiply by 17 = 102 (not "103" as above formula ilustrates)??
The "number" of "days" on duty in a week is in J10; the dollar amount is calculated in K10. Is it possible to apply different formulas (IN THE SAME CELL, i.e. "K10") for each respective number, as follows:
1 day = $20 (round-up)
2 days = $30 (round-down)
3 days = $50 (round-down)
4 days = $70 (round-up)
5 days = $85 (true)
6 days = $100 (round-down)
7 days = $120 (round-up). As above, 7 multiply by 171428571428 = $120.
Configuration: Windows XP Firefox 3.5.5
Append cells from multiple excel files to one excel file Can read text from one cell to another in excel Excel copy from one cell to another Excel equation does one cell equal another Excel if formula to change cell formatting Excel include formula in cell reference Excel results in one cell means automatic value in another Excel when one cell contains x all cells should convert to red How do i set a formula in excel to sum one cell from two other cells How to split one cell data into multiple cells excel vba If then excel statements comparing one cell but using data from another In excel from one cell to fill out a report and database In excel my formula clears out when changing a cell In excel, how do make what i type in one cell auto fill in select others Lookup one cell in excel and return a whole column in new column formula One cell automatically generates another cells value excel Pasting more than one formula formula on excel without any chanaging cell refrences Take text from one cell and include in formula