-
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.
f31
-
Need help to expand IF formula please
The formula below works as intended but I need some help please, to expand the formula so that if F31 is greater than 0 but less than 1195, it would return F31 and if F31 is greater than 1195, it would return 1195. =IF(F31>0,E27, 0) Thanks!- leopardhawk
- Thread
- f31 formula greater return
- Replies: 7
- Forum: Excel Questions
-
B
Macro not firing when cell value changes
Good morning! I am trying to get this macro to fire when the value in cell F31 changes. The macro hides and un-hides specific rows based on the value in F31. F31 values are changed by a pull down menu. I'm trying to hide all values not pertaining to the choice made from the pull down...- billfinn
- Thread
- f31 false macro pull true
- Replies: 11
- Forum: Excel Questions
-
L
Need to clear the contents in F4 & F5 when the value is changed in cell F29.
Hello there, I am quite new to VBA. I have an issue to be resolved. I need a code to clear the contents in F4 & F5 when ever the value in F 29 is changed manually. And also new values from F31 & F32 needs to be copied to F4 & F5 everytime it happens. Kindly help on it please! Regards, Liju- leejoos
- Thread
- changed clear contents f31 f32
- Replies: 5
- Forum: Excel Questions
