Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use an If Or function
n M1 a date is entered in the 02-Sep-05 format
in range P13:P15 I have day cost fees, [ P13 1.50], [ P14 2.00], [P15 2.50] In P4 the formula {=TEXT(M1,"ddd")} which denotes 2nd. Sep as Wed, 3rd.Sep as Thu, 4th. Sep as Wed Now in P5 I want to enter a fee relevant to the day name Displayed in P4 would be if P4 = Fri then day cost = $1.50 , if P4=Thu then day cost = $2.00, if P4= Wed then day cost = $2.50 Hope this is explains it |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use an If Or function
I dont get it... 2nd Sep hasn't been a Wednesday since 1998 and wont be
again until 2009. Were you just guessing? You might be looking for a formula like: =IF(P4 = "Fri", P13, IF(P4="Thu", P14, IF(P4="Wed", P15, -12345))) Instead of TEXT(), you might be interested in WEEKDAY() -- Rob van Gelder - http://www.vangelder.co.nz/excel "RedChequer" wrote in message ... n M1 a date is entered in the 02-Sep-05 format in range P13:P15 I have day cost fees, [ P13 1.50], [ P14 2.00], [P15 2.50] In P4 the formula {=TEXT(M1,"ddd")} which denotes 2nd. Sep as Wed, 3rd.Sep as Thu, 4th. Sep as Wed Now in P5 I want to enter a fee relevant to the day name Displayed in P4 would be if P4 = Fri then day cost = $1.50 , if P4=Thu then day cost = $2.00, if P4= Wed then day cost = $2.50 Hope this is explains it |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use an If Or function
"Rob van Gelder" wrote: I dont get it... 2nd Sep hasn't been a Wednesday since 1998 and wont be again until 2009. Were you just guessing? You might be looking for a formula like: =IF(P4 = "Fri", P13, IF(P4="Thu", P14, IF(P4="Wed", P15, -12345))) Instead of TEXT(), you might be interested in WEEKDAY() -- Rob van Gelder - http://www.vangelder.co.nz/excel "RedChequer" wrote in message ... n M1 a date is entered in the 02-Sep-05 format in range P13:P15 I have day cost fees, [ P13 1.50], [ P14 2.00], [P15 2.50] In P4 the formula {=TEXT(M1,"ddd")} which denotes 2nd. Sep as Wed, 3rd.Sep as Thu, 4th. Sep as Wed Now in P5 I want to enter a fee relevant to the day name Displayed in P4 would be if P4 = Fri then day cost = $1.50 , if P4=Thu then day cost = $2.00, if P4= Wed then day cost = $2.50 Hope this is explains it I answered this reply but i don't think iw was posted.t |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |