ExcelBanter - IF Formula

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

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

- - IF Formula (https://www.excelbanter.com/excel-discussion-misc-queries/245464-re-if-formula.html)

RonaldoOneNil

IF Formula

=IF(B4=82,B4*7,IF(B472,B4*5,IF(B4=63,B4*3,0)))

":: Amy ::" wrote:

I need help with formula that will calculate a payout for

Basic Stretch Super Strech
63 $3.00 72 $5.00 82 $7.00

for example...
employee 1 has 65
employee 2 has 75
employee 3 has 82

I put this formula together but my amounts are not coming out correct...
=IF(B4=82,(B4*7)),IF(B472<82,(B4*5),IF(B4=63<72 (B4*3),0))

--
Still Learning...

All times are GMT +1. The time now is 08:36 AM.