-
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 false
-
P
Works as formula but doesn't work as VBA
Hi. I have the below code which isn't working in VBA. The formula works perfectly as a formula placed manually in the cell but doesn't work as part of the macro. It seems to be the "" at the end of the formula which is confusing it. Please can somebody help? Sub FillEXTEND()...- Pete2211
- Thread
- formula formulas if false vba works
- Replies: 11
- Forum: Excel Questions
-
A
Multiple if function...
Hello, I think I'm needing some type of multiple if function, but am not sure. I am wanting to create one formula that will calculate the TARGET SKU QUANTITY (column K). I provided two examples below. Here are the steps for the formula (USING ROW 3 AS EXAMPLE): #1. B3 * 6 = INVENTORY UNIT...- andoano
- Thread
- if false if true
- Replies: 9
- Forum: Excel Questions
-
C
VBA - if false, pop up window to prompt user to enter value
Hello, I am looking for a formula, using an IF statement, where if true, it populates a number, and if false, a pop-up window opens prompting user to enter the number that should be there. Formula i'm working working with: =IF(D2="OFF",8,AskForValue()) I've also entered a VBA Code i found...- chrono2483
- Thread
- if false pop up vba
- Replies: 5
- Forum: Excel Questions
