c20

Trying to get cell C20 to display the word "Need" if number in cell D20 is a negative number. If cell D20 is a positive number I would like cell C20 to say the word "Over". Example: C20.....D20 Need -15,567 C20.....D20 Over 16,567 if the number is negative dispaly the word Need if the...

I have two set of tables: 1) In the first table I have a series of percentages associated each with a code (e.g. C2, C18, C20): <tbody> C2 C18 C20 C12 C5 C6 20% 16% 20% 5% 4% 12% </tbody> 2) In the second table I have values associated with the same codes as in the first table (i.e. C2...

If I have a drop down list with 5 options in it (say cell A1) and I wish to create a further dropdown list in cell A2 looking at lists in cells B2 to B20, C2 to C20, etc. with a header at the top of each list based on which option was selected in A1, what formula/function would I use in A2 please.

On one sheet, I have data at C19, C20 and C21. I want to be able to just pull down the formula so that it'll automatically show the data from the same cells, but 3 columns over... so, for example. C19, C20, C21 F19, F20, F21 I19, I20, I21 L19, L20, L21 I want to be able to copy down a list...

In my current spreadsheet it would really help to have shortcuts within the sheet. For example when I'm at, say, C20 it would be nice to have a quick way of getting to F300. Are there any buttons or something that I can put near C20 that would take me there? I'd prefer to avoid VBA. Thanks!

Hi, Experts Thanks in advance for your respond I need a VBA code to perform the below task Active workbook1 .xlsm - to random selective range of cells with Live formula to Copy Paste Value to WB2 on Cell: C19 and save it as new file .xlxs (file name VALUE AT CELL C20 and date DD-MM-YYYY)...