Missing parenthenses ? =roundup((C4/(1-D4,1))

**zjadh123** · 12-15-2022, 04:35 AM

trying to roundup a sales price based on cost/gross margin % but cant seem to find where i'm missing parenthenses. any advice would be appreciated, thank u!

=roundup((C4/(1-D4,1))

**sandy666** · 12-15-2022, 04:38 AM

=roundup((C4/(1-D4,1)))

( x 3
but
) x2 should be 3 but this is still wrong

or try

Formula:

Please Login or Register  to view this content.

4.44

0.2

5.6

=ROUNDUP(C4/(1-D4),1)

**zjadh123** · 12-15-2022, 05:28 AM

thank u so much!

**sandy666** · 12-15-2022, 05:34 AM

You are welcome

Missing parenthenses ? =roundup((C4/(1-D4,1))

LinkBack

Thread Tools

Rate This Thread

Display

Missing parenthenses ? =roundup((C4/(1-D4,1))

Re: Missing parenthenses ? =roundup((C4/(1-D4,1))

Re: Missing parenthenses ? =roundup((C4/(1-D4,1))

Re: Missing parenthenses ? =roundup((C4/(1-D4,1))

Thread Information

Users Browsing this Thread

Similar Threads

Automatically fill in missing numbers from a list, adding a cell for each missing number

How to solve average rolling with missing value by select data before find missing value

[SOLVED] Using VLOOKUP and SUM with ROUNDUP ignoring values that are missing or non-criteria text

[SOLVED] Compare two columns on separate sheet, if missing, insert missing data

Data missing in WorkBooka after VBA Macro SAVE AS due to ComboBox source is missing

Excel Macro to find missing dates and insert missing date as blank row

On Error? Creates 1 missing worksheet then never detects any other missing worksheets

Bookmarks

Bookmarks

Posting Permissions