-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
if function?
-
J
blank cells & #DIV/0! error
I want to be able to copy the formulas in D2 & G2 down the columns but I have no data yet to put in B4,5,6, etc & ditto F4,5,6, etc so I get a #DIV/0! error code. Is there any way to have the formulas in the D & G columns before having values in the B & F columns without generating the error...- Jeffsk
- Thread
- #div/0! error blank cells if function?
- Replies: 4
- Forum: Excel Questions
-
L
Help using If Function
Hello, I am trying to automate the entry of certain text in a cell "C3" based on drop down in another cell "N16". when i select an item from drop down , the formula works and enters text in cell "C3" But when i again select another item from dropdown the existing text is replaced by new text...- laxminarayana
- Thread
- if function if function text string if function?
- Replies: 2
- Forum: Excel Questions
-
T
I need an Excel genius
Hi This is probably very simple for you experts out there but I'm stuck! In one cell I will have a number, if under 1300 I want the cell beside it to say LOW, if over 1300 but under 1800 I want it to say MEDIUM and if over 1800 I want it to say HIGH. Sometimes it will be blank so if I can...- tommyturner
- Thread
- if function?
- Replies: 6
- Forum: Excel Questions
