ExcelBanter - Need help with IF formula

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

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

- - Need help with IF formula (https://www.excelbanter.com/excel-discussion-misc-queries/172274-need-help-if-formula.html)

Deepak

Need help with IF formula

Value in Cell should give result in B1
A1 - Yes, Then it should show B1 - 10
A1 - No, Then it should show B1 - 5
A1 - N/a, Then it should show B1 - 0

Thanks in advance

Don

JE McGimpsey

Need help with IF formula

One way:

B1: =IF(A1="Yes",10,IF(A1="No",5,IF(A1="N/a",0,"Invalid value in A1")))

In article ,
Deepak wrote:

Value in Cell should give result in B1
A1 - Yes, Then it should show B1 - 10
A1 - No, Then it should show B1 - 5
A1 - N/a, Then it should show B1 - 0

Thanks in advance

Don

iliace

Need help with IF formula

=VLOOKUP(LOWER(A1),{"yes",10; "no",5; "n/a",0},2,FALSE)

On Jan 9, 10:40 am, Deepak wrote:
Value in Cell should give result in B1
A1 - Yes, Then it should show B1 - 10
A1 - No, Then it should show B1 - 5
A1 - N/a, Then it should show B1 - 0

Thanks in advance

Don

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