ExcelBanter - IF Statement that looks at two fields

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statement that looks at two fields (https://www.excelbanter.com/excel-discussion-misc-queries/224287-if-statement-looks-two-fields.html)

mellermj

IF Statement that looks at two fields

I have two fields that I have to look at and based on those fields either
apply a specific number or have it equal the calculation in another fields.

Age (b2)
SCr (b5)

=IF(B269 AND B5<1, 1, B5)

That doesn't work. Any advise or help would be appreciated.

T. Valko

IF Statement that looks at two fields

Try it like this:

=IF(AND(B269,B5<1),1,B5)

--
Biff
Microsoft Excel MVP

"mellermj" wrote in message
...
I have two fields that I have to look at and based on those fields either
apply a specific number or have it equal the calculation in another
fields.

Age (b2)
SCr (b5)

=IF(B269 AND B5<1, 1, B5)

That doesn't work. Any advise or help would be appreciated.

FSt1

IF Statement that looks at two fields

hi
try this ......
=IF(AND(B269,B5<1),1,B5)

regards
FSt1

"mellermj" wrote:

I have two fields that I have to look at and based on those fields either
apply a specific number or have it equal the calculation in another fields.

Age (b2)
SCr (b5)

=IF(B269 AND B5<1, 1, B5)

That doesn't work. Any advise or help would be appreciated.

Chris Bode

=IF(AND(B269, B5<1),1,B5)

Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com

All times are GMT +1. The time now is 09:02 AM.