Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF problem
Hopefully someone can help me with this - its doing my head in!
I have a formula which is supposed to work out the next working day a certain number of days after an invoice date. So far so good and I use the following: =WORKDAY(D2+I2-1,1,'Holiday Range') Where D2 is the invoice date and I2 is the number of days after the invoice date. However, I also want the Holiday Range to vary depending upon the currency which is located in F2. The currency will be one of three - GBP, EUR or USD. Can anyone with a fresh brain help me with this. TIA, Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with nested if function. PLS HELP | Excel Worksheet Functions | |||
Problem with nested IF and OR formula? | Excel Discussion (Misc queries) | |||
Nested if problem | Excel Worksheet Functions | |||
Nested IF problem - help please | Excel Worksheet Functions | |||
Problem with nested IF_OR statement | Excel Worksheet Functions |