| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I input these formulas into cells that I want written in?
If an employee input a dollar amount into G12, can I mandate he fill in what
the purpose was in A12? If he doesn't fill in the annotation in A12, then he has to remove the dollar amount in G12 before proceeding with the rest of the form. The highest dollar amount used in G12 would be $75. Want dollar amount in G12 Want text in A12 I can make it work outside my cells with Cell I formula =IF(AND(G120,A12=""),"Error"," ") Cell J formula =IF(AND(G120,A12=""),"Need to fill out column A","OK") How do I make it work inside my cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically use the newest number input in the formulas | Excel Discussion (Misc queries) | |||
| how to account the number of cells which is bank and written? | Excel Discussion (Misc queries) | |||
| Quickest way to input formulas? | Excel Discussion (Misc queries) | |||
| Hidden rows unhide themselves when formulas are written | Excel Discussion (Misc queries) | |||
| Formulas containing variable input | Excel Discussion (Misc queries) | |||
Threaded Mode
