ExcelBanter - Excel Formula

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

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

- - Excel Formula (https://www.excelbanter.com/excel-discussion-misc-queries/182291-excel-formula.html)

TRA

Excel Formula

I'm new at this. Can anybody tell me how to do a formula for the following:

If A3,A4,A5,A6,A7 =0, B10=0
If A3 or A4 ="X", B10 =B2*3
If A5 or A6= "X", B10 = B2*4
If A7 = "X", B10 = B2*5

FSt1

Excel Formula

hi,
ya ready......
=IF(AND(A3=0,A4=0,A5=0,A6=0,A7=0),0,IF(OR(A3="X",A 4="X"),B2*3,IF(OR(A5="X",A6="X"),B2*4,IF(A7="X",B2 *5,0))))

regards
FSt1

"TRA" wrote:

I'm new at this. Can anybody tell me how to do a formula for the following:

If A3,A4,A5,A6,A7 =0, B10=0
If A3 or A4 ="X", B10 =B2*3
If A5 or A6= "X", B10 = B2*4
If A7 = "X", B10 = B2*5

Gary''s Student

Excel Formula

Try this array formula:

=IF(AND(A3:A7=0),0,IF(OR(A3="X",A4="X"),B2*3,IF(OR (A5="X",A6="X"),B2*4,IF(B7="X",B2+5,99))))

--
Gary''s Student - gsnu200777

"TRA" wrote:

I'm new at this. Can anybody tell me how to do a formula for the following:

If A3,A4,A5,A6,A7 =0, B10=0
If A3 or A4 ="X", B10 =B2*3
If A5 or A6= "X", B10 = B2*4
If A7 = "X", B10 = B2*5

All times are GMT +1. The time now is 05:22 AM.