Help with a complex formula

J

joseph66

New member
Joined
Oct 2, 2017
Messages
8
Reaction score
0
Points
0
Location
South Wales
Excel Version(s)
2013
Hello All,

I have a big problem...

I Need to check if the name in one cell is one of 2 values if the cell equals 1 name then do this, if it is another then do this then if neither then do this..


=IF(C13="EDF",G13*32/17,)*IF(C13="Gooch",G13*15,G13*17/15)

I am ok with this the equation is ugly but it works. However I also what to check another cell that has another value ...


=IF(F20=0,G20*24,F20*0.128)...

I wish to combine these formula, the result goes into the same cell which is cell I...


Please help...:frusty:
 
Hi,

What is going to be the overall logic of the final formula?
 
The final result is that a cell will show a final figure,

This will depend on whether a cell contains the following text If C2="EDF" then multiple G2 by 32, if C2 = "Gooch" then multiple G2 by 17, if neither of these then multiple, 24. if the cell is empty then take what is in cell G2 then multiple by 0.128 which will be displayed in cell I2 This will set up the cost of the work do be done, so charity help can be given if need be thanks!!!
 
Hello joseph66,

Try this one-

=IFERROR(IF(C13="EDF", G13*32/17,IF(C13="Gooch", G13*15, IF(F20=0,G20*24,F20*0.128),G13*17/15))

if it is ok then its gud otherwise attach your sheet
 
All the number should be from the same line, sorry if that caused confusion...
 
Then change every instance of 13 to 20 or every instance of 20 to 13… then put the formula on row 20, or 13 depending on which you have chosen.:doh:
 
Tried and was :frusty:told too many arguments for this function...
 
Does this work? Based on your description in #3 above...

=G2*IF(C2="EDF",32,IF(C2="Gooch",17,IF(C2="",0.128,24)))
 
Hello all, thanks for the help, the above looks good, however it does not generate a result if there is a figure in F2 which would be multiplied by 0.128.:sorry:


The crux of that matter is if Cell C2 contains the text EDF then G2 gets multiplied by 32, if Cell C2 contains the text Gooch then G2 get multiplied by 17 other value then G2 gets multiplied by 24, however if Cell G2 is empty then cell F2 gets multiplied by 0.128....:thumb:


Sorry if I have caused any confusion ready to accept any swear words...:yield:
 
Ok then:

=IF(G2="",F2*0.128,G2*IF(C2="EDF",32,IF(C2="Gooch",17,24)))
 
Last edited:
You must log in or register to reply here.
Back
Top