Forum Discussion
Conditional formulas
H387 is the sum of H column
If H387 would exceed to 10,000 (H387>=10,000) then H2*0.25 otherwise H2*0.45
Please advise the formula
If H387 would exceed to 10,000 (H387>=10,000) then H2*0.25 otherwise H2*0.45
Please advise the formula
3 Replies
- You need to make H387 an absolute reference, like this: $H$387
- =IF(H387>=10,000,H2*0.25,H2*0.45)
- But that doesn’t work my friend.
H387 in the formula is keep changing on every row, I want that remain same.
Please advise
