Hi,
i just want to know how to select the option which i want when i use if function like = if (c5/26*400>c5/14*230,if it rue ,if it false ) i want to say select the c cheapest option how to use it
kind regards
hazem Amin
Hi,
i just want to know how to select the option which i want when i use if function like = if (c5/26*400>c5/14*230,if it rue ,if it false ) i want to say select the c cheapest option how to use it
kind regards
hazem Amin
I'm not exactly sure that I understand, but it sounds like you want a MIN() function in there somehow. Calculate the two options, then use the MIN() function to choose the smaller of the two.
Originally Posted by shg
Not sure i understand what you want to do - as the IF statement is doing the choice
IF C5/26*400 is greater than c5/14*230 then if that is true the next argument in the if statement is true and selected
= if (c5/26*400>c5/14*230, " C5/26* 400 is greater " , " c5/14*230 is greater " )
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
HI there
I understand that but i want to said to if to choose the cheapest option in the statement to to said to if because i don't know which one will be the cheapest
= if (c5/26*400>c5/14*230, " C5/26* 400 is greater " , " c5/14*230 is greater " )
Thanks
Hazem Amin
well you do from those tests
where the result is
" C5/26* 400 is greater "
then the other one is cheaper
so you can replace those two statements and also carryout a calculation statements
= if (c5/26*400>c5/14*230, " C5/26* 400 is greater " , " c5/14*230 is greater " )
If (c5/26*400>c5/14*230, " Use this c5/14*230 is greater as its cheaper" , "use this C5/26* 400 as it is cheaper " )
now it will display one of those messages
and if you just wanted to do the calculation
do this
If (c5/26*400>c5/14*230, c5/14*230, C5/26* 400 )
or explain in more detail , sorry I see that english is not your 1st language , so if possible explain further
Thank you very much
did that work as you wanted ?
truly not as i wanted because i couldn't realize which option is true or which option is false If (c5/26*400>c5/14*230, c5/14*230, C5/26* 400 ),that is mean when i run my formula on the list of numbers , i don't know which will be the cheapest . c5/14*230 or C5/26* 400
Thanks for your help and support
the first option is truetruly not as i wanted
so
c5/26*400
needs to be greater than
c5/14*230
for
c5/14*230
to calculate
if thats not how you wanted it
can you explain further
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks