|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 7th, 2004, 12:06 PM
|
|||
|
|||
Excel if formula maybe
I want a formula to do this
if c2 = Holiday or Bank Hol then display 8 (in the cell im typing the formula) if not do another formula (on the info in c2) 
|
|
#2
July 7th, 2004, 12:07 PM
|
|||
|
|||
|
Excel if formula maybe
=IF(ISNUMBER(MATCH(C2,Holidays,0)),8,X)
where Holidays refers to a range housing (bank) holiday dates and X an expression that you want to evaluate when C2 is not a holiday date. wrote in message ... I want a formula to do this if c2 = Holiday or Bank Hol then display 8 (in the cell im typing the formula) if not do another formula (on the info in c2)
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula - IF Formula & Conditional Formatting | rhhince | Worksheet Functions | 1 | June 20th, 2004 06:34 PM |
| Excel changes my formula when I add values! | MJ13 | General Discussion | 7 | June 17th, 2004 04:38 PM |
| Excel formula for year calc. | Bobby | New Users | 3 | May 11th, 2004 04:07 PM |
| Copying a Formula from NotePad to Excel | carl | Worksheet Functions | 4 | March 21st, 2004 09:25 AM |
| Formula Layout Excel | Thor's Castle | Worksheet Functions | 2 | March 16th, 2004 04:53 PM |
Linear Mode
