help with nesting ISNUMBER/AND formuals please

[MARKY J]

Hi,

I am creating a pivot table combined with tables for my boss. I need the formula to do the following:
using ISNUMBER read if a cell (A6) contains the number "62", If no then return "", if it does AND another cell (K6) contains 12% it will return 125, if not then return 75

really racking my brains and cannot solve your help is much appreciated

[:) Sixthsense :)]

Try this..

Please Login or Register  to view this content.

---
Sixthsense

[Nels]

Note sure if the "62" and "12%" you mentioned is numeric input or textual input,
so the following formula is for textual input for A6 and K6:

Please Login or Register  to view this content.

Try it if it helps

[MARKY J]

sorry prob didn't explain very well, in the cell a6 there is a mixture of text and numbers e.g. HJ62VAF so need to search if this cell contains the number 62, if it doesn't i want to return blank, if it does, i then want it to search cell K6 which will either display 12% or another value. If it is 12% I want to return 125 and if any other value return 75?? I have tried the above suggestions but just displaying blank even though both criteria are true.
cheers

[Nels]

Try this, I tested and it works in my machine:

Please Login or Register  to view this content.

[MARKY J]

thank you so much works a treat!

[:) Sixthsense :)]

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[MARKY J]

I now need to do the opposite! if cell A6 contains any other number lower than 62 i need to display the sum of cell j6 x k6, thanks

[:) Sixthsense :)]

I don't know which formula is worked for you, just replace the nearby nothing "" (of 62) in to j6*k6

---

Sixthsense

[MARKY J]

Hi,
The formula =IF(TYPE(FIND("62",A6))<>1,"",IF(K6=12%,125,75)) worked fine for the result i desired, in a different cell i need to read the same cell A6 which contains AJ62VAF and return blank if the cell contains the number 62, and if it contains anyother number lower than 62 to display the result of j6 x k6. your help is much appreciated