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
|
|||
|
|||
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
|
|||
|
|||
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 |