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>=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
