Russ At Index
Well-known Member
- Joined
- Sep 23, 2002
- Messages
- 706
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hi ,
Am stuck on a solution for the following problem . In column B i have assorted numbers 1 -99 for example . In column
A i have text , either 20 or 40.
I would like a formula which shows me the number greater than 20 which is in column B IF the word in column A says 40.
So , if row 1 column A had 40 as text and row 1 column B had 35 as number the answer i would like to see is 15 .
Any help greatly appreciated ,
Kind regards,
Russ.
Am stuck on a solution for the following problem . In column B i have assorted numbers 1 -99 for example . In column
A i have text , either 20 or 40.
I would like a formula which shows me the number greater than 20 which is in column B IF the word in column A says 40.
So , if row 1 column A had 40 as text and row 1 column B had 35 as number the answer i would like to see is 15 .
Any help greatly appreciated ,
Kind regards,
Russ.