May 30 2022 01:39 PM
Hello,
I have a question about the IF function
I need to program a cell with this conditioning IF((J13<=15);(I13*J13);(I13*15). Note that i want to limit the factor in 15.
I want that this conditioning only occours when i select "unjustified" in other cell (H14) in a collumn configured with VLOOKUP function, if negative, i want the cell to show "0"
My Excel is in PT-BR
Can someone help me?
Thank you.
May 30 2022 02:02 PM
Solution@gandriol Hope all is well! This might help:
=iF(H14<>"unjustified",0,if(J13<=15,I13*J13,I13*15)). Hopefully this helps but let me know if I have misunderstood anything.
May 30 2022 02:17 PM - edited May 31 2022 04:37 AM
=IF(H14="unjustified", I3*MIN(J13, 15), 0)
May 30 2022 02:02 PM
Solution@gandriol Hope all is well! This might help:
=iF(H14<>"unjustified",0,if(J13<=15,I13*J13,I13*15)). Hopefully this helps but let me know if I have misunderstood anything.