Forum Discussion
Solved
IF to check multiple cells and formula for each depending on result
Hi all, So the use for this is a trade journal. You take a trade/position, it has 3 take profits which close a % of the trade. The cell I'm trying to create is a Stop loss. How big the position c...
Here's the formula:
=IF(I2="",O2*1,IF(K2="",O2*0.8,IF(M2="",O2*0.4,O2*0.2)))You might also see it written like:
=IF(ISBLANK(I2),O2*1,IF(ISBLANK(K2),O2*0.8,IF(ISBLANK(M2),O2*0.4,O2*0.2)))
Brilliant break down I appreciate you taking the time, I didn't even know that existed. Bear with me having such little understanding.
That's correct, * all by the value in cell O2.
That's correct, * all by the value in cell O2.
Here's the formula:
=IF(I2="",O2*1,IF(K2="",O2*0.8,IF(M2="",O2*0.4,O2*0.2)))
You might also see it written like:
=IF(ISBLANK(I2),O2*1,IF(ISBLANK(K2),O2*0.8,IF(ISBLANK(M2),O2*0.4,O2*0.2)))- That's spot on. Thanks for that Patrick, much appreciated!
- You're welcome!