IF to check multiple cells and formula for each depending on result

Copper Contributor

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 currently is depends on which take profit level was hit last, if any.


I'm trying to create IF function that scans 3 cells

if empty perform a simple formula

if not empty move onto next cell

if final cell is empty perform a simple formula, if final cell is not empty provide alternate formula


What I have so far, no idea if I'm close I'm not great with excel so I use google searches to find results.




As you can see the final IF function has two formulas, my little understanding of it suggests the second "" means 'Not blank' to which it goes on to perform *0.2.



Thanks a lot for you help. I hope it's clear!




5 Replies


I strongly recommend using the function arguments menu when getting started with logical formulas (It's a big help with IF-OR and IF-AND, especially). It will help you step through the arguments and avoid errors.


As you can see from above, the first logical test results in TRUE, so Excel will go to the Value if True (Box) but it doesn't understand *1 because the * is a multiplier.  


What would you like to do for these bolded parts? Do you need to multiply those percentages by the value in a cell?



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.
best response confirmed by Budgen (Copper Contributor)



Here's the formula:



You might also see it written like:

That's spot on. Thanks for that Patrick, much appreciated!