how to have a cell contain 3 diffrent formulas

[jryoung91]

Hi,

is there a way a cell can contain 3 different formulas and then preform one of the formulas on the value of a different cell?

so if cell a1 contains the word "high" then this formula is preformed in b1. if cell a1 contains "medium" then this formula is preformed and if cell a1 contains "low" then this formula is preformed.

high - =IF(COUNTA(J2:N2)=0,I2+30,(MAX(J2:N2)+30))
medium - =IF(COUNTA(J2:N2)=0,I2+90,(MAX(J2:N2)+90))
low - =IF(COUNTA(J2:N2)=0,I2+120,(MAX(J2:N2)+120))

i just wanted to know if i can combine all three formulas so if the word changes in cell A1 then the correct formula would be used in B1

sorry if this makes no sense and any help would be appreciated

[Glenn Kennedy]

Paste this into B1...

Please Login or Register  to view this content.

[daffodil11]

Please Login or Register  to view this content.

[zmster2033]

jr,

You may be needing a nested if statement if I am understanding correctly.

Formula should be: =if(a1="high",IF(COUNTA(J2:N2)=0,I2+30,(MAX(J2:N2)+30)),if(a1="medium",IF(COUNTA(J2:N2)=0,I2+90,(MAX(J2:N2)+90)),IF(COUNTA(J2:N2)=0,I2+120,(MAX(J2:N2)+120)))

This is untested but I feel this should work and what I would try if I were you.

[jryoung91]

Thanks, massive help! all sorted

[Norie]

Perhaps.

Please Login or Register  to view this content.

Or even this.

Please Login or Register  to view this content.

[samba_ravi]

=IF(OR(A1={"High","Medium","Low"}),IF(COUNTA(J2:N2)=0,I2,MAX(J2:N2))+VLOOKUP(A1,{"High",30;"Medium",90;"Low",120},2,0),"")
try this

[Jonmo1]

Assuming A1 can only be 1 of the 3 values, low medium or high..

Try
=IF(COUNT(J2:N2),MAX(J2:N2),I2)+30*MATCH(A1,{"High","","Medium","Low"},0)

[Richard Buttrey]

...
or perhaps

Please Login or Register  to view this content.