| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to insert function?
if cell h4=16, subtract 15, if cell h4=31 subtract 30,if cell h4=46 subtract 45 does any one know if all this can be included in one formula? Many thanks in anticipation of your reply -- tmela ------------------------------------------------------------------------ tmela's Profile: http://www.excelforum.com/member.php...o&userid=37745 View this thread: http://www.excelforum.com/showthread...hreadid=573580 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert function?
It looks like you want the remainder after dividing by 15.
If that's true: =mod(H4,15) tmela wrote: if cell h4=16, subtract 15, if cell h4=31 subtract 30,if cell h4=46 subtract 45 does any one know if all this can be included in one formula? Many thanks in anticipation of your reply -- tmela ------------------------------------------------------------------------ tmela's Profile: http://www.excelforum.com/member.php...o&userid=37745 View this thread: http://www.excelforum.com/showthread...hreadid=573580 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert function?
=IF(H4=46,H4-45,IF(H4=31,H4-30,IF(H4=16,H4-15,H4))) ' pasted into A1 the
result in A1 is what you wanted tmela. "tmela" wrote: if cell h4=16, subtract 15, if cell h4=31 subtract 30,if cell h4=46 subtract 45 does any one know if all this can be included in one formula? Many thanks in anticipation of your reply -- tmela ------------------------------------------------------------------------ tmela's Profile: http://www.excelforum.com/member.php...o&userid=37745 View this thread: http://www.excelforum.com/showthread...hreadid=573580 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to insert function?
This type if statements must be run backwards. The lowest statement is met
every time the highest statement is met, therefore you must test from highest to lowest. "Rookie 1st class" wrote: =IF(H4=46,H4-45,IF(H4=31,H4-30,IF(H4=16,H4-15,H4))) ' pasted into A1 the result in A1 is what you wanted tmela. "tmela" wrote: if cell h4=16, subtract 15, if cell h4=31 subtract 30,if cell h4=46 subtract 45 does any one know if all this can be included in one formula? Many thanks in anticipation of your reply -- tmela ------------------------------------------------------------------------ tmela's Profile: http://www.excelforum.com/member.php...o&userid=37745 View this thread: http://www.excelforum.com/showthread...hreadid=573580 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to insert a function within a sentence in Excel 200 | Excel Worksheet Functions | |||
| function to insert a picture | Excel Worksheet Functions | |||
| pethow do i insert a Yes/No function into a cell in Excel? | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Challenging Charting | Charts and Charting in Excel | |||
Linear Mode
