ExcelBanter - Posible IF formula

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Posible IF formula (https://www.excelbanter.com/new-users-excel/198431-posible-if-formula.html)

Hanah

Posible IF formula

A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this.

M Kan

Posible IF formula

I think this is the formula in B2

=IF(A2=1000,140,IF(A2=2000,14,117))
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"Hanah" wrote:

A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this.

Hanah

Posible IF formula

Thanks! This works! Great help!

"M Kan" a scris:

I think this is the formula in B2

=IF(A2=1000,140,IF(A2=2000,14,117))
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips

"Hanah" wrote:

A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this.

All times are GMT +1. The time now is 10:41 PM.