User Profile
rhancock
Brass Contributor
Joined Sep 29, 2020
User Widgets
Recent Discussions
Re: Excel Help for fairly new user
sumrall90 I think it might help if you know the elements of the formula used: =+B6+(@'Dec 14-20'!D6:E6) translates to "Add the cell B6 in this worksheet to cells D6 through E6 on the sheet 'Dec 14-20'" You can change that formula manually, or you can click in the total cell, type: + click B6 type + click the cell in the other sheet to add to. Hope that's clear 🙂 To c1.5KViews1like1CommentRe: Excel Formula
Ahmed2500 Quick and ugly since I'm in a hurry, but put the number to be evaluated into E3 and use this formula: =IF(0>$E$3>70,$E$3*0.05,IF(71>$E$3>99,(0.05*70)+(($E$3-70)*0.15),IF($E$3>100,(0.05*70)+(0.15*30)+($E$3-100)))) Also, here is a better forum for questions about Excel: The Microsoft Excel Community939Views0likes0CommentsRe: Excel - percentage
jana_d Type "0.01" into a blank cell anywhere (do not use quotes) Copy the cell which has 0.01 Highlight/select all of the cells showing 4500% Paste Special - Multiply Also, you might have better luck in the future in the Excel forum 🙂 The Microsoft Excel Community2.2KViews1like2Comments
Recent Blog Articles
No content to show