"If" function with Multiple Ref Cells in Text and Return Value

[cychua]

Hi All
I have a form to calculate value with "if" or just return blank or "-".
I am not sure what type of functions i should use and how to link 3 words to returns value<(with max option), i think i am doing it correctly in max function, just the combination, i am confused with>

Example,

E2 + F2 + G2 = SEA, IMP, LCL = =MAX(ROUNDUP((F14/1000),0),(ROUNDUP(G14,0)))

E2 + F2 + G2 = (Any others combinations of words) = Blank or "-"

I had attached with the file together. Hope that you guys able to help out. Thanks.

[wfm007]

There u go....

****if it works then don't forget to click on STAR button below the post

[Kevin UK]

Hi cychua

Something like this!

Please Login or Register  to view this content.

[cychua]

Thanks WFM and Kevin. Both of you guys's formula is good and easy to understand!

[Kevin UK]

Hi cychua

Glad to be of some help and thank you for the feed back.